|
|
Posted by Erland Sommarskog on 10/01/29 11:32
Alex via SQLMonster.com (no@spam.pls) writes:
> Mike thanks for the response. I do not really need to do any XPath
> operations on the level of the database. I believe the XML data type
> should be slower and probably take more space to store than NTEXT or
> VARCHAR(max). At this momemnt I just want to find out whether storing
> data in SQL will be slower/faster than storing same data using millions
> of regular files.
My guess is that regular files are faster, but its definitely more
difficult to manage, as there is no transactional control for file-
system and database operations.
If you are to store the data in the database, don't use the deprecated
ntext data type. I would agree with Mike that the xml type is the best
choice, but if you only want to store raw text, then nvarchar(MAX)
should be your choice.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|