Previous Thread
Next Thread
Print Thread
Hop To
#207040 02/22/2008 6:35 PM
Joined: Aug 2006
Posts: 1,659
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,659
Likes: 1

This is probably a dumb question, but I'm curious what exactly constitutes a "query" (as seen in the debug footer) -- I mean, I know basically what a query is, but can't figure out this discrepancy...

My Forum says total of 21-23 queries
ubbcentral says 11-13 queries
ubbdev & fanfocus say 8 queries

Why would I have so many more queries (I have fewer forums than here), and why would the number of queries change reloading the same page?


GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 8.1.34 / MySQL 5.7.23-23 / Apache 2.4.67
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #207041 02/22/2008 6:43 PM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
When a page is loaded your seeing the results of XX queries.

So your Database is being asked xx times for info.
In the form of a query for each.

It may rise and fall depending on how many users are online
or how many forums are active, but i'm not that sure.

Thats my take on it wink


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Mark S #207044 02/22/2008 6:51 PM
Joined: Aug 2006
Posts: 1,360
Likes: 2
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,360
Likes: 2
Cached information is updated once in a while, and updating those is triggered by normal pageloads. Each time a page is loaded a check is made if something extra has to be done, and if so, it does it.

So one time it might just load the page you are looking at, the next time it will also update the who's online island, and next time it updates an RSS feed etc.

That explains why the number of queries can differ each time you load the same page.


[Linked Image from siemons.org]
Yarp #207045 02/22/2008 7:05 PM
Joined: Aug 2006
Posts: 1,659
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,659
Likes: 1

Thanks, yeah, I understand the different # of queries per page load, but any idea why I'd have so many more queries total than the other sites mentioned?



GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 8.1.34 / MySQL 5.7.23-23 / Apache 2.4.67
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #207052 02/22/2008 7:59 PM
Joined: Aug 2006
Posts: 1,360
Likes: 2
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,360
Likes: 2
I just had a look as guest on your forum, and only had 8 queries on the main index. Could be that it runs an extra mile in updating cache information because you are logged in as admin. Don't really know, it's a wild guess.


[Linked Image from siemons.org]
Yarp #207058 02/22/2008 8:49 PM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
When ever i read questions of a unknown i like to reply
with "Its because your special" wink


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Are any of these legitmate?
by Baldeagle - 09/06/2026 1:37 PM
After server reboot
by Morgan - 09/02/2026 8:27 AM
Email Settings
by Outdoorking - 05/13/2026 2:44 AM
Who's Online Now
1 members (Gizmo), 156 guests, and 110 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)