View Issue Details

IDProjectCategoryView StatusLast Update
0000547XMB1Bugspublic2019-12-29 02:32
ReportermiqrogrooveAssigned Tomiqrogroove 
Status resolvedResolutionfixed 
Product Version1.9.11.11 
Target Version1.9.11.16Fixed in Version1.9.11.16 
Summary0000547: Avoid "ORDER BY pid" in topicadmin
DescriptionWhen querying the posts table with a "tid" condition and a "pid" order, the MySQL engine must decide which of the two indexes to use. It tends to choose incorrectly when a LIMIT is also applied. In forums with large posts tables, this can result in several seconds of table scanning. Using the new style "dateline, pid" order restores performance.
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Original Reporter
SVN Revision2776


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-12-06 00:02 miqrogroove New Issue
2019-12-29 02:13 miqrogroove Assigned To => miqrogroove
2019-12-29 02:13 miqrogroove Status new => assigned
2019-12-29 02:14 miqrogroove Target Version =>
2019-12-29 02:32 miqrogroove Product Version =>
2019-12-29 02:32 miqrogroove Status assigned => resolved
2019-12-29 02:32 miqrogroove Resolution open => fixed
2019-12-29 02:32 miqrogroove Fixed in Version =>
2019-12-29 02:32 miqrogroove SVN Revision => 2776