Posted by Mike Epprecht \(SQL MVP\) on 06/12/15 11:32

Hi

Use SQL Server 2005 and load the XML files into the new XML data type.

http://msdn2.microsoft.com/en-us/library/ms190936.aspx

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Performance: SQL table vs NTFS via SQLMonster.com" <no@spam.pls> wrote in
message news:5780ab7f8a064@uwe...
>I have a .NET application that needs to work with about 5,000,000 XML files
> 5Kb each. Mostly the application randomly reads these files and it
> adds/modifies about 100 files every 10 minutes. What would be the best
> data
> storage in tirms of performance (connection, search and retrieval times) a
> big SQL table that uses NTEXT to store XML or regular NTFS file system
> (500
> folders with 10,000 files each)? How big the difference will be?
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200511/1

[Back to original message]