View Issue Details

IDProjectCategoryView StatusLast Update
0000489XMB1Bugspublic2020-09-18 16:10
Reportermiqrogroove Assigned To 
Status newResolutionopen 
Summary0000489: Who's Online Optimization
DescriptionSaves 1 query:

For the majority of forums, $count < $tpp, and $page < 2, therefore it is not necessary to query $count at all unless $page isset, or the query returns $tpp rows.

Larger issue:

The who's online page seems to use 1 query for each user who is viewing a thread. This shouldn't be needed.
Additional Information
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Original Reporter
SVN Revision



2017-12-28 06:58

administrator   ~0000375

Punting as low priority.

Issue History

Date Modified Username Field Change
2012-01-30 15:42 miqrogroove New Issue
2012-02-15 21:59 miqrogroove Target Version =>
2017-12-20 07:10 miqrogroove Target Version =>
2017-12-28 06:58 miqrogroove Priority normal => low
2017-12-28 06:58 miqrogroove Target Version =>
2017-12-28 06:58 miqrogroove Note Added: 0000375
2020-09-18 16:10 miqrogroove Priority low => normal
2020-09-18 16:10 miqrogroove Description Updated