Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (driv), 35 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/22/06
Posts: 163
Top Posters (30 Days)
Ruben 51
DennyP 24
Gizmo 24
Dunny 15
SteveS 14
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#207040 - 02/22/08 05:35 PM # of queries?
jgeoff Offline
Pooh-Bah
Registered: 08/08/06
Posts: 1922
Loc: NJ

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.5.6)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (Win7 and iPhone); No IE, ever!
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#207041 - 02/22/08 05:43 PM Re: # of queries? [Re: jgeoff]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
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
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#207044 - 02/22/08 05:51 PM Re: # of queries? [Re: Mark S]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
Loc: Breda, NL
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.
_________________________
Top
#207045 - 02/22/08 06:05 PM Re: # of queries? [Re: Yarp™]
jgeoff Offline
Pooh-Bah
Registered: 08/08/06
Posts: 1922
Loc: NJ

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.5.6)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (Win7 and iPhone); No IE, ever!
Top
#207052 - 02/22/08 06:59 PM Re: # of queries? [Re: jgeoff]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
Loc: Breda, NL
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.
_________________________
Top
#207058 - 02/22/08 07:49 PM Re: # of queries? [Re: Yarp™]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
When ever i read questions of a unknown i like to reply
with "Its because your special" wink
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10491 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image