Previous Thread
Next Thread
Print Thread
Hop To
#207040 02/22/2008 6:35 PM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
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 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
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,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
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,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
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 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
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,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
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
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
1 members (1 invisible), 920 guests, and 238 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)