News Portals and database heaviness

What is database design solutions for news portals with high trrafic? Could file system be a good solution?

开发者_StackOverflow社区mysql > File system

Thanks in advance

Look into memcached. It is designed to "cache" objects and data. The best way to use it is to cache your news query results for 5 minutes, as an example. Therefore only one query gets executed every five minutes instead of each time a visitor views the page.

The filesystem is not a good solution for caching (unless you have a FusioIO card).

Generally, the delay involved in reading the file from disk is much higher than a caching system such as Memcache or APC.

There's also the option of using Sphinx or Lucene to index the database periodically, returning results much faster than standard MySQL.

An RDBMS is much more suited to high traffic than a file system is. I would stick with using RDBMS for data unless it is proved that for a particular type of data, a file-system or some other solution is better.

High traffic? PostgreSQL is more robust, can handle more concurrent users. noSQL-databases are also getting populair, but these have different behaviour and functionality. You can't compare them with a RDBMS like PostgreSQL, Oracle or something like that.