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

Lacks the index of "topic_last_post_id"

    XMLWordPrintable

    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
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: