Alex
Nov 23, 2005
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/Forum...eneral/200511/1
View 3 Replies
Mar 21, 2002
Thanks for the replies but...
I doesn't work!!!!
Anymore ideas?
---------------------------------------------
Hi,
I have a rather odd problem that hopefully you'll be able to shed some light on (nobody else has come up with anythig sensible).
We want to back up the databases to a hard drive held on another server so I mapped the drive in explorer to the drive then went into Enterprise manager and tried to create a backup device and it won't see the mapped drive.
I've tried mapping to my PC and I can see that via enterprise managers backup stuff (infact any PC in the office works) but it won't see any of the servers even though we can map to them and access them via windows explorer.
I've tried when logged on via sa and the windows NT administrator and still no luck. In fact no matter what I type or do it fails and keeps telling me device error or device off line which it isn't.
On our test instance of SQL Sever we can backup to other servers but not the new live version!
Any thoughts on what might cause this to happen?
Helen
View 3 Replies
View Related
