Log in

View Full Version : 111 Queries


SmEdD
05-28-2003, 09:29 AM
Running "Database Optimization" in vbPortal is crazy queries. :p

Wanna kill a server run it with like 20 others doing it too. A true test on the server.

[QUOTE]Page generated in 1.42570901 seconds (47.17% PHP - 52.83% MySQL) with 111 queries.
[Debug Mode OFF] [PHP v4.1.2] [GZIP enabled - level 9] [Server Load: 0.19 ? 0.16 : 0.16]

Xenon
05-28-2003, 09:58 AM
you should reduce gzip to level 1 it's really enough :)

N9ne
05-28-2003, 10:14 AM
EEK! Gzip level 9 = not healthy. Switch to level 1 immediately!

and 111 queries :-O

PHP 4.1.2, its like a grandad server! Get 4.3.1 !!!

Erwin
05-28-2003, 10:41 AM
vBPortal is like that unfortunately, if you switch on all the modules.

SmEdD
05-28-2003, 11:22 AM
Ya I know. Right now I have them all off but the news and I'm running 36. So I'm trying to fix up the queries as much as I can.

Tony G
05-28-2003, 11:29 AM
Ouch, Level 9 will leave a dint if it's left like that. :p

N9ne
05-28-2003, 06:13 PM
Outside Australia, we call dints dents :)

Smoothie
05-28-2003, 06:36 PM
I've seen this guys site here, can't remember the link, but I'll dig it up:
195 queries.....

SmEdD
05-28-2003, 06:55 PM
lol . . . Dints such a great word.

Boofo
05-28-2003, 07:04 PM
Today at 02:36 PM Smoothie said this in Post #8 (https://vborg.vbsupport.ru/showthread.php?postid=401199#post401199)
I've seen this guys site here, can't remember the link, but I'll dig it up:
195 queries.....

Are you talking about JJR512?

Tigga
05-28-2003, 07:23 PM
Probably...

http://www.jjr512.com/

I'd love to know who he's hosted with. I would think they're pretty good if they can actually handle all that strain. :)

Oh, anyone know if that's vBportal he's using?

Boofo
05-28-2003, 07:48 PM
Those queries come from the forums he has listed at the top and bottom of the page.

N9ne
05-28-2003, 07:49 PM
Haha, 200 queries on his homepage and 113 on his forum home, this guy's suiciding...

SmEdD
05-28-2003, 07:50 PM
WTF!!! How do you get so many. And his forums . . . 103?? Thats a little much for vbulletin. Insanly mad!

N9ne
05-28-2003, 07:51 PM
A little much Steve?! 103 is insane! I have 21 on my forumhome and 0 on my forumhome [i'm not a portal kinda guy, i dont like smokin' my server]...103, any query count in triple figures is worrying.

SmEdD
05-28-2003, 08:00 PM
Oh 103 isn't me. The 111 up on first post is and I did that on pourpose to tset the server load. But ya any over 40 is really bad I say. And how you have 0 on forumhome? You need to call the forums do you not?

Smoothie
05-28-2003, 08:09 PM
Today at 04:04 PM Boofo said this in Post #10 (https://vborg.vbsupport.ru/showthread.php?postid=401208#post401208)
Are you talking about JJR512? ya, thats it.

Erwin
05-28-2003, 09:33 PM
If that site gets busy, it WILL crash.

SmEdD
05-31-2003, 02:08 AM
My fully functional no options taken away vB.

Page generated in 0.20423701 seconds (51.51% PHP - 48.49% MySQL) with 10 queries.

I can't knock off any more tho :(

Gary King
05-31-2003, 10:20 PM
05-28-03 at 04:51 PM N9ne said this in Post #15 (https://vborg.vbsupport.ru/showthread.php?postid=401231#post401231)
A little much Steve?! 103 is insane! I have 21 on my forumhome and 0 on my forumhome [i'm not a portal kinda guy, i dont like smokin' my server]...103, any query count in triple figures is worrying.

0 on your forumhome? Now that's what I call optimization! ;)

Boofo
05-31-2003, 10:23 PM
This is actually what he said:

I have 21 on my forumhome and 0 on my forumhome

which contradicts itself.

Gary King
05-31-2003, 10:25 PM
I know, I was only joking.

Boofo
05-31-2003, 10:41 PM
I gathered that. So was I. ;)

Link14716
05-31-2003, 10:46 PM
Arcade main page:
Page generated in 0.48532701 seconds (55.96% PHP - 44.04% MySQL) with 157 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP enabled - level 1] [Server Load: 0.54 ? 0.85 : 1.57]

Gary King
05-31-2003, 10:54 PM
Today at 07:41 PM Boofo said this in Post #23 (https://vborg.vbsupport.ru/showthread.php?postid=402597#post402597)
I gathered that. So was I. ;)

Oh alright :)

Tony G
06-01-2003, 10:08 AM
Query overload!! :p

*Goes Crazy*

Xenon
06-01-2003, 02:22 PM
hmm, i can tell what we have on forumhome, but i think everyone already knows that ;)