|
|
Posted by Performance: SQL table vs NTFS via SQLMonster.com on 11/17/05 18:03
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]
|