92 queries in forum index

Hi,

I just found out that my index page has more dan 92 queries, my host is starting to complain :nervous: How can i reduce the amount of queries??

I have a lot of hacks installed

hidjra

[g-force2k2]

what hacks do you have installed on the forumhome? if you look at the thread in help me finish forum TECK posted something worth taking three queries and making it one regards...

g-force2k2

[Erwin]

93 would kill any server. Keep in mind a stock vB has 17 queries on the index page (I think). Take out the hacks that uses loops eg. ones that does queries on each forum you have.

[hidjra]

Originally posted by g-force2k2
what hacks do you have installed on the forumhome? if you look at the thread in help me finish forum TECK posted something worth taking three queries and making it one regards...

g-force2k2

i managed to reduce the amount of queries from 92 to 37 by;

Removing;
- https://vborg.vbsupport.ru/showthrea...=lasttitlehack
- https://vborg.vbsupport.ru/showthrea...forumthreadvew

And by using;
- https://vborg.vbsupport.ru/showthrea...threadid=43305

Thanx for the tip. But i still have a long way to go, 37 queries is still a lot!

hidjra

[hidjra]

Originally posted by Erwin
93 would kill any server. Keep in mind a stock vB has 17 queries on the index page (I think). Take out the hacks that uses loops eg. ones that does queries on each forum you have.

That would be a good a reason for my host to go crazy :cheeky:

hidjra

[Erwin]

37 queries is a far cry from 93 - that's a lot better.

What's the URL to your forums?

Try to get it to below 30 - remove queries and hacks that are unnecessary.

[TECK]

my forums have 14queries on forumhome...
what's the url? and hacks exacly did you installed?

[hidjra]

Originally posted by Erwin
37 queries is a far cry from 93 - that's a lot better.

What's the URL to your forums?

Try to get it to below 30 - remove queries and hacks that are unnecessary.

thanx, still working on it, i have installed a lot of small hack which i can't even remember installing.

This is the url to my forum
http://community.marokko.nl/forums/

http://community.marokko.nl/forums/i...hp?=&explain=1

hidjra

[TECK]

first of all, you are using vb224, in other words you expose yourself (security issues).

second, all those queries (example):
"SELECT template FROM template WHERE title='P_themeheader' "
are just template names that you forgot to cache into $templateused. for each title you forgot, you add a query.

third, you have few hacks that you van spare them... ex member of the day, etc. you have a busy board, so think server wise...

if i would be you i would upgrade asap, to 227 and start hacking slowly again the new board, checking aways the queries.
you could also install in your pc vbulletin so you can do your home work there first.
read this tutorial i made:
https://vborg.vbsupport.ru/showthrea...threadid=39482

let me know if you have any questions...

[hidjra]

[QUOTE]Originally posted by TECK
[B]first of all, you are using vb224, in other words you expose yourself (security issues).

second, all those queries (example):
"SELECT template FROM template WHERE title='P_themeheader' "
are just template names that you forgot to cache into $templateused. for each title you forgot, you add a query.

thanx this works, got it down to 33 queries

if i would be you i would upgrade asap, to 227 and start hacking slowly again the new board, checking aways the queries.
you could also install in your pc vbulletin so you can do your home work there first.
read this tutorial i made:
https://vborg.vbsupport.ru/showthrea...threadid=39482

let me know if you have any questions...

i was already planning to do this, just did'nt have the time, thanx for the advice.

hidjra