If one does neither use the cron clean up feature nor the built in crawler the boost_cache table is quite useless.

Disabling writes by using a blackhole table has improved the performance on our DB server quite a bit.

CommentFileSizeAuthor
#3 boost-609310.patch7.61 KBmikeytown2
#1 boost-609310.patch3.91 KBmikeytown2
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

mikeytown2’s picture

Component: Expiration logic » Caching logic
Category: bug » feature
Status: Active » Needs review
FileSize
3.91 KB

This is more of a feature request rather then a bug report.

Once the file is created, it will never be overwritten; editing a node will not remove the old file. boost_cache_expire() uses the database instead of glob when flushing a node on edit. Your current setup is on the edge if this is slowing down you DB.

Anyway here's a patch... Key part is inside boost_cache_set() disabling

    boost_db_prep($filename, $extension, BOOST_TIME + $expire);
    boost_cache_set_node_relationships($GLOBALS['_boost_relationships']);

If I get multiple requests for this (10+) or get paid, or if a better patch comes out I will commit it & support this feature request.

mikeytown2’s picture

mikeytown2’s picture

FileSize
7.61 KB

This isn't that painful to do actually... so here it is.

mikeytown2’s picture

Status: Needs review » Fixed

committed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.