PDA

View Full Version : # of queries..

Webmasta XT
09-03-2002, 06:27 PM
Page generated in 0.83308196 seconds (70.69% PHP - 29.31% MySQL) with 50 queries.

Is there a way to reduce the # of queries? cuz 50 is alot.. :hurt:
g-force2k2
09-03-2002, 06:45 PM
webmasta XT on what part of the forum are you producing this amount of queries? regards...

g-force2k2
Webmasta XT
09-03-2002, 07:31 PM
just the main page.. http://www.xtreme-forumz.net/
Erwin
09-03-2002, 07:52 PM
Mmm... try removing some of the hacks in your index.php.
g-force2k2
09-03-2002, 08:28 PM
i've heard webmasta XT that the who was online today hack produces alot of queries? so see if you got that installed... if so remove it and see what happens? regards...

g-force2k2
Webmasta XT
09-03-2002, 09:00 PM
Originally posted by g-force2k2
i've heard webmasta XT that the who was online today hack produces alot of queries? so see if you got that installed... if so remove it and see what happens? regards...

g-force2k2

Did that and this is the result I got..
Page generated in 0.99540806 seconds (55.27% PHP - 44.73% MySQL) with 49 queries.
g-force2k2
09-03-2002, 09:05 PM
okay what kind of hacks to you have installed on the forumhome that transpond a lot of queries? regards...

g-force2k2
Webmasta XT
09-03-2002, 09:11 PM
This is what i got after removing all the hacks.. (almost all)

Page generated in 0.56171405 seconds (85.23% PHP - 14.77% MySQL) with 21 queries.
Webmasta XT
09-03-2002, 09:12 PM
Originally posted by g-force2k2
okay what kind of hacks to you have installed on the forumhome that transpond a lot of queries? regards...

g-force2k2


Don't have a clue... this just started happening for some reason, b4 it was under 30.. :paranoid:
Erwin
09-03-2002, 11:38 PM
Usually hacks that involve the list of forums on your homepage eg. show sub-forums, or show last title in forum (if it's not PPN's version) are culprits.
Webmasta XT
09-04-2002, 06:47 PM
PPN's hack, lol
chr@nox
09-06-2002, 02:39 PM
i'm not really sure but doesn't the top 5 produce a query for every name/thread that is put there?

also the Forum Statistics part uses alot of query's...
comment them out for a sec and see what happens?
Learner29
09-07-2002, 11:23 AM
yeah if the option is only in the older verisons of vbulletin.. how can i
down-grade my vbulletin to the older verison? I have good reasons so please
dont give me ++++ about it. But I think this is a most for admins. Its
just my opinion.. but again.. how can i down grade?


easy, king sting::::

take your old copy of vbulletin and install it on your server, then use your
database with it changing the config.php file.

just remember : that means you are ready to tolerate all the security holes
that were discovered in the old versions....