Hello,

I’ve noticed I have some queries that are performing slowly:

SELECT t.* FROM bb_topics AS t WHERE t.topic_status = ‘0’ AND t.topic_sticky = ‘2’ ORDER BY t.topic_time DESC LIMIT 30

The index the db is using is forum_stickies which is a composite index of (topic_status, forum_id, topic_sticky, topic_time)

THe problem is since the query thats created doesn’t include forum_id, mysql is not able to utilize the composite index completely and performs an additional filesort which slows the performance of the query.

To fix this, I can either create a new index that doesn’t include the forum_id field OR somehow force the code to include the forum_id conditional in the query. I only have one forum and I only plan on having one forum per a database.

I can hack the code, but I suspect there is a setting somewhere that can fix this issue. Any ideas?

Thanks!

[@chrishajer Participant 15 years, 8 months ago]

What version are you using? There were some performance improvements, including adding indexes, but it would depend on your version.

Also, rather than hacking your installation, please consider filing a trac ticket to be sure the fix is evaluated and implemented for everyone.

https://trac.bbpress.org/

[@chrishajer Participant 15 years, 8 months ago]

https://trac.bbpress.org/changeset/1638

https://trac.bbpress.org/ticket/876