[PHPBB3-11079] Lacks the index of "topic_last_post_id" - phpBB Tracker

XML

Word

Printable

Details

Type: Improvement
Status: Closed (View Workflow)
Priority: Minor
Resolution: Invalid
Affects Version/s: 3.0.11
Fix Version/s: 3.0.15-RC1
Component/s: Database Abstraction Layer (DBAL)
Labels:
None
Environment:
PHP 5.3.3-7+squeeze14, MySQL(i) 5.1.49-3, Firefox 15.0

GitHub Pull Request URL:
https://github.com/phpbb/phpbb3/pull/1233

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

Reporter:: AleSSaNDRo

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 30/Aug/12 1:45 PM

Updated:: 15/Jan/17 8:23 PM

Resolved:: 15/Jan/17 8:23 PM