View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000410XMB1Bugspublic2011-01-04 16:192017-12-28 14:07
Reportermiqrogroove Assigned Tomiqrogroove  
PrioritynormalSeveritytweakReproducibilitysometimes
Status closedResolutionfixed 
Product Version1.9.10 
Target Version1.9.11.11Fixed in Version1.9.11.11 
Summary0000410: Member Profile Code Needs to be Optimized
DescriptionThe code for "Last post" and "Forum most active in" returns outrageously large and complex data sets when only a finite number of results are needed. As a result, the member profile view scales poorly as the member's post count increases.
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision2483

Relationships

related to 0000529 closedmiqrogroove Unnecessary HAVING Clause in member.php Query 

Activities

miqrogroove

2011-02-03 08:37

administrator   ~0000298

This bug was introduced in 1.9.9 and carried over into 1.9.10.

miqrogroove

2011-02-03 20:04

administrator   ~0000299

Remaining inefficiency is due to lack of an appropriate index in the posts table. I'm not aware of any pressing need to improve this at the moment.

Issue History

Date Modified Username Field Change
2011-01-04 16:19 miqrogroove New Issue
2011-02-03 08:34 miqrogroove Status new => confirmed
2011-02-03 08:37 miqrogroove Note Added: 0000298
2011-02-03 08:37 miqrogroove Product Version => 1.9.10
2011-02-03 19:01 miqrogroove Status confirmed => assigned
2011-02-03 19:01 miqrogroove Assigned To => miqrogroove
2011-02-03 20:04 miqrogroove SVN Revision => 2483
2011-02-03 20:04 miqrogroove Note Added: 0000299
2011-02-03 20:04 miqrogroove Status assigned => resolved
2011-02-03 20:04 miqrogroove Fixed in Version => 1.9.11.11
2011-02-03 20:04 miqrogroove Resolution open => fixed
2011-02-11 09:45 miqrogroove Status resolved => closed
2017-12-28 14:07 miqrogroove Relationship added related to 0000529