Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-13447

Add index for phpbb_topics.topic_type for ucp_front

    XMLWordPrintable

Details

    Description

      The page UCPs front page is quite slow, due to a query on the topics table that does not use an index:

      SELECT t.* , tp.topic_posted, tt.mark_time, ft.mark_time AS forum_mark_time
      FROM community_topics t  LEFT JOIN community_topics_posted tp ON (tp.topic_id = t.topic_id
      AND tp.user_id = ***) LEFT JOIN community_topics_track tt ON (tt.topic_id = t.topic_id
      AND tt.user_id = ***) LEFT JOIN community_forums_track ft ON (ft.forum_id = t.forum_id
      AND ft.user_id = ***)
      WHERE t.topic_type = 3
      AND t.forum_id IN (***)
      ORDER BY t.topic_last_post_time DESC, t.topic_last_post_id DESC

      Before: 0.25902s | After: 0.78104s | Elapsed: 0.52203s

      Attachments

        Activity

          People

            Marc Marc
            nickvergessen Joas Schilling
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: