Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-11079

Lacks the index of "topic_last_post_id"

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Invalid
    • Icon: Minor Minor
    • 3.0.15-RC1
    • 3.0.11
    • Database Abstraction Layer (DBAL)
    • None
    • PHP 5.3.3-7+squeeze14, MySQL(i) 5.1.49-3, Firefox 15.0

      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.

            Marc Marc
            AleSSaNDRo AleSSaNDRo
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: