Where best to store long text data

[achmo]

Hello,

I am building an ASP system for ordering articles online (the articles themselves are not online). Part of the information I need to store for every article is an abstract, which gets to about 1000 characters or less. My question is, where is best to save the abstract information - in text files, which I will read from my asp page, or in the articles table itself in my sql database (in which case, using what datatype - varchar? ntext?)

Thank you for your help

Yael Achmon

 

[ChainsawJoe]

I think this is a case of which would you be more comfortable using? I personally would go for database ntext every time, but if you fancy using textfiles, then go for it!
It won't be as scalable with textfiles, and may become very cumbersome. SQL databases can easily and quickly handle fields of large size - just look at the

image

datatype!

hope that helps!