Displaying articles using ASP

[Guest_imported]

Hello!

I'm developing a new portal site, and I have a problem. There will be lots of articles on this portal and I want to handle them using asp (display them, catalog them, and SEARCH through them).
What is better in the servers point of view: should I store articles in a database and query the database with SQL or should I store them in separate text files. What's using less server resources?

Remember I want to search in articles and want to arrange them in categories, and also want users to be able to post reviews to the articles.

What method should I use?

(sorry if my English is bad)

 

[Tarwn]

If you store them as text you will need to store a large number of reference and cross-reference for each one, as well as do text searches through the files when necessary. Creating references, indexing articles, and creating the engine to efficiently do text searches through the contents will take a great deal of time and provide a large load on your system.
If you go with a database and design the system similar to a digital library, most of your referencing and so-on will still take some time, but not nearly as much, and you have the built in search and cross-referencing capabilities of a database, a program that has already been designed for efficiency and data storage and retrieval.
In the long run using a database will consume less resources both on the server and in human working hours. If you want documentation on digital article storage and digital libraries you can find some at:

http://www.iLumina-dlib.org

(go to publications link at bottom)

http://nsdl.nsf.gov

http://www.smete.org

The first is a library I actually worked a great deal on, the second is the National Science Digital Library, and the third is SMETE. You could also look at resources concerning Merlot and IMS language specification (xml based spec for describing resources for data transference).

If you would like some more pointers, feel free to ask
-Tarwn ------------ My Little Dictionary ---------
Extreme Programming - (1)Trying to code before my second cup of coffee. (2) While(1){ Ctrl+C; Ctrl+V; }
FAQ - Web-ese for "Forget Asking Questions, I am to busy"

 

[Guest_imported]

Thanks it was helpful!