I’ll probably copy this to TRAC but it’s good for a discussion here too?

I’ve been poking around the results using the query list plugin and something hit me.

Options are not being preloaded (ie. SELECT meta_value FROM $bbdb->topicmeta WHERE topic_id = 0)

However a few options, like active plugins MUST be loaded on every load. So the options table has to be queried at least once, usually two or three times. This causes extra queries.

So the question is, what’s slower, unserializing possibly serialized data in half a dozen to a dozen options, or making half a dozen to a dozen extra mysql queries?

Preloading could be a plugin, the cache code is already there. Just wondering if I should bother working on it given the above question.

[@_ck_ Participant 17 years, 5 months ago]

er, omg, tracing the code I think the option has already been written into bbpress and just not documented?

$bb->load_options = true

put into config.php ?

can it be that easy? does it work or not ready for primetime?