CODEWITHSUNDEEP
phpmysqlperformancescalability
jasmine
jasmine

Reputation:

News Portals and database heaviness

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

mysql > File system

Thanks in advance

Upvotes: 0

Views: 519

Answers (4)

Andre
Andre

Reputation: 3181

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.

Upvotes: 1

Frank Heikens
Frank Heikens

Reputation: 126970

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.

Upvotes: 0

St. John Johnson
St. John Johnson

Reputation: 6660

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.

Upvotes: 2

Raj More
Raj More

Reputation: 48018

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.

Upvotes: 0

Related Questions