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

Lacks the index of "topic_last_post_id"

    Details

      Description

      Please add, in MySQL database, index on "topic_last_post_id" (and maybe also on "topic_moved_id").

      Table: phpbb_topics

      I have a forum with 617539 posts and now, when I added this index, the forum is not finally takes several seconds to load pages.

      In https://www.phpbb.com/community/viewtopic.php?f=71&t=2161708 there is a discussion about.

        Attachments

          Activity

            People

            • Assignee:
              Marc Marc
              Reporter:
              AleSSaNDRo AleSSaNDRo [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: