I just realized today if you are using a bunch of plugins that have their options stored in the bbpress meta, your query count has jumped on every page in bbPress 1.0.x

Apparently 1.0 now has a reserved list of option names that are pre-loaded, instead of *all* of them like 0.9 could. Plugins have to add their desired names to the pre-caching option, which of course 100% of all pre-exisiting plugings are not aware of, so they all cause an extra query in 1.0

This isn’t a magic bullet by any means but you can at least fix this behavior. There isn’t any flag you can turn on to cache all (that would be far too easy) but you can fool the routine by loading all the options before it gets around to it.

Simply make the below into a mini-plugin, or right click here

and save as _load-options.php in your my-plugins/ directory

I strongly suggest you save it with a leading underscore so it auto-loads.

<?php

/*

Plugin Name: Load Options

*/



global $bbdb;

$results = $bbdb->get_results( "SELECT meta_key, meta_value FROM $bbdb->meta WHERE object_type = 'bb_option' ");

foreach ( $results as $options ) {

wp_cache_delete( $options->meta_key, 'bb_option_not_set' );

wp_cache_set( $options->meta_key, maybe_unserialize( $options->meta_value ), 'bb_option' );

}

?>

[@tomcraft1980 Member 15 years, 4 months ago]

This drastically reduces page-gerenation and database querries!

GREAT!

[@takster Member 14 years, 11 months ago]

Instantly knocked 3 queries from my mainpage, thanks

[@mr_pelle Participant 14 years, 5 months ago]

Marvellous!

[@_ck_ Participant 13 years, 10 months ago]

I am bumping this as it’s become more important since so many people have upgraded to 1.x and the problem still exists (and gets magnified with every extra plugin you install).