By joris_lucius on

Hi all,

I have a question concerning performance on a large-scale Drupal install that contains many views. I couldn't find answers on Google/ Drupal.org, so hope someone here could give me an answer.

The table 'cache_views' contains the records: 'views_tables:nl'
In the 'data' field here, we allready got '[BLOB - 703,0 KB]'. For all testing now, it seems ok. But what if many users (ie 1000+ a day) will visit the site? Will this have a heavy impact on performance?

Thanx in advance for an answer.

⋅ Categories: Drupal 5.x

Comments

Jo Wouters’s picture

Jo Wouters commented

Joris,

It is indeed odd that a cached data-object has to be this big.
For high-volume websites, you might consider moving this cache bin (cache_views) to the filesystem using the cacherouter module.
That way you limit the load on the database-server.

Jo

adam_b’s picture

adam_b commented

You might want to post your question at http://groups.drupal.org/high-performance