bbPress

Info

• 2 posts
• 1 voice
• Started 4 years ago by _ck_
• Latest reply from _ck_
• This topic is not resolved

Tags

• cache
• mysql
• performance
• speed

• Posts in this topic

performance idea, preloading general options

1. • 
   • _ck_
   • Moderator

   • Posted 4 years ago #

   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.
2. • 
   • _ck_
   • Moderator

   • Posted 4 years 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?

3. You must log in to post.