performance idea, preloading general options
-
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.
- You must be logged in to reply to this topic.