Hey,

I was just working on a faster variables module. (see here: http://drupal.org/sandbox/Fabianx/1172558)

I just noticed boost is running a variable_set('boost_statistics_html') each time in boost_block, when the AJAX Statistics block is enabled.

That is one additional DB Write, but what weights worse is that it clears the variable cache each time, which means they need all to be fetched from DB. (and it renders my module useless :-D. )

Could you include cache.inc in boost instead and cache the output?

Also would it not be more efficient to store the statistics in a cache bin and just for example update core DB via cron to really make this efficient?

Best Wishes,

Fabian

Comments

gdud’s picture

gdud commented

I'm also the same problem with boost. For a few minutes I have hundrets variable_set calls.

For each one, cache variables is clearing (strongarm and schema too).

It's not good for cache table and produces dedlock.

dr.admin’s picture

dr.admin commented

I'm also the same problem with boost on large Drupal 6 site.

dr.admin’s picture

dr.admin commented

i changed variable_set to memcache_variable_set and now is ok.