I am very interested to known if it's a good idea to store article's content in a database?

Do all big sites like CNN.COM store their articles in a database?

Yes, and yes.

What other storage mechanism would you suggest as an alternative?

__________________
Visit my blog at http://leedumond.com
Follow me on Twitter: http://twitter.com/LeeDumond

Thanks.

I was just wondering how this is done.

Yevi,

Take a look at the tbh_articles table, specifically the body field. This is an nText field that can hold a very large amount of textual data. If you look at the data in the field you will see that the text is formatted with HTML.

This is very common, and the norm for most medium to large sites, even small ones like the Beer House or Computer Scribe. Part of the reason is that it is much easier to edit or create a data record and pour it into a template than it is to edit or create a static HTML page and add it to a site, and deal with all the site navigation to include a new page.

If news sites had to use static pages they'd just now be getting around to notifying the world of the sinking of the Titanic


Steve