Is there anyway I can avoid a database call on each page request, without enabling page cache?

Is this achievable for drupal sites? Please give me some suggestion. Having hard time scaling a drupal site which has around 2 million hits per day.

Comments

yelvington’s picture

Drupal assembles pages out of the database and cache, so the answer is no.

You can cache objects in memory using memcached, or with APC's object cache feature. Either way, you should already be using APC or some other PHP compiler/bytecache.

For anonymous pageviews, Boost is an easy, huge improvement, caching pages in the filesystem so Apache serves them directly without even engaging Drupal.

A more complex solution: http://drupal.org/project/authcache

newbie888’s picture

use your own database for busy contents.