View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000547XMB1Bugspublic2019-12-06 00:022020-10-20 18:17
Reportermiqrogroove Assigned Tomiqrogroove  
PrioritynormalSeverityminorReproducibilityrandom
Status closedResolutionfixed 
Product Version1.9.11.11 
Target Version1.9.12Fixed in Version1.9.12 
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
Browser
Flags
Original Reporter
SVN Revision2776
Git Commit

Activities

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 => 1.9.12
2019-12-29 02:32 miqrogroove Product Version => 1.9.11.11
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 => 1.9.12
2019-12-29 02:32 miqrogroove SVN Revision => 2776
2020-10-20 18:17 miqrogroove Status resolved => closed