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.