View Issue Details

IDProjectCategoryView StatusLast Update
0000489XMB1Bugspublic2020-09-18 16:10
Reportermiqrogroove Assigned To 
PrioritynormalSeveritytweakReproducibilitysometimes
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 Informationhttp://forums.xmbforum2.com/viewthread.php?tid=776654
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision

Activities

miqrogroove

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 1.9.11.13 => 1.9.11.14
2017-12-20 07:10 miqrogroove Target Version 1.9.11.14 => 1.9.11.15
2017-12-28 06:58 miqrogroove Priority normal => low
2017-12-28 06:58 miqrogroove Target Version 1.9.11.15 =>
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