Skip to:
Content
Pages
Categories
Search
Top
Bottom

what is forum_id?


  • mechamecha
    Member

    @mechamecha

    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!

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.