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

Add index for phpbb_topics.topic_type for ucp_front

    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

            • Assignee:
              Unassigned
              Reporter:
              nickvergessen Joas Schilling [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: