blob text or varchar?

[francesco]

hi everyone a question for all you wise men out there! ;-)

i run a db with thousands of reviews, interviews, article and so on. What's better: 1) leaving all the articles on .txt files and then using the file system object to show them in the page; 2) insert the articles in the db splitting them in several varchar fields 3) insert the articles in the db using the text/blob fields

thanx, it's a very hard question for me!

[Juergen Leis]

Either use
1) Indexing the Articles with Index Server or
3) Adding a Full Text Index to your Table

What You choose is a matter of taste.
But in SQL server You have all things in one place,
you can exploit the advantages of relational databases
and backup and restore additional data, articles etc. in one consistent step.

------------
francesco at 1/10/2002 5:59:31 AM

hi everyone a question for all you wise men out there! ;-)

i run a db with thousands of reviews, interviews, article and so on. What's better: 1) leaving all the articles on .txt files and then using the file system object to show them in the page; 2) insert the articles in the db splitting them in several varchar fields 3) insert the articles in the db using the text/blob fields

thanx, it's a very hard question for me!