|
|
Posted by Mike Epprecht \(SQL MVP\) on 10/01/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
Navigation:
[Reply to this message]
|