View Full Version : Gars causing high queries ?
miyukichii
01-25-2008, 12:14 AM
I am curious does GARS cause server intensity ? How much queries does it eat ?
Morgan
01-25-2008, 12:23 AM
Turn debug mode on by adding the following to your vB config.php file and then load a page with GARS and look at footer of the page:
$config['Misc']['debug'] = true;
miyukichii
01-25-2008, 05:12 AM
Turn debug mode on by adding the following to your vB config.php file and then load a page with GARS and look at footer of the page:
$config['Misc']['debug'] = true;
After which code/line should i exactly add this code ?
And where can i find the debug mode ?
Morgan
01-25-2008, 01:18 PM
On a new line after the <?php will do. Afterwards look at the footer on any vB based page.
MissKalunji
02-12-2008, 05:01 AM
hi!
i've been wondering the same thing. Every thread in Gars take sup to 20 queries (i've tried removing every customization) and it's still between 19-20 (the main forum display is ok cut it down to 17) but showthread 20 queries? is there any way to cut down? stripping down?
Morgan
02-13-2008, 09:19 PM
How many queries do you see for showthread that is not a GARS related showthread? Subtract the two numbers. Is that an excessive number? Also, when in debug mode, click the question mark in the 'Queries Executed X (?)' line to see the queries. Are those queries necessary? Are any queries examining a ton of rows? Those are a couple of things to look at when evaluating whether something is running excessive or costly queries.
MissKalunji
02-19-2008, 01:29 AM
I did my research right before you Replied and it adds 4 queries.
Is that the standard amount?
A standard Thread is about 13 to 15 queries. But i was just investigating to find out what was causing my loads and it wasn't Gars ;) I'm just trying to cut down on everything that's all...
Morgan
02-21-2008, 09:13 PM
It depends but IMO four 'good' queries is not a lot. 'Good' means necessary and doesn't examine a ton of rows. Sometimes two queries are better than one query, but again it all depends.
MissKalunji
03-04-2008, 04:40 PM
Yep Cool Thanks
vBulletin® v3.8.5, Copyright ©2000-2012, Jelsoft Enterprises Ltd.