Queries on Vbulletin..

[Polo]

How many queries are just too much?

On my site some pages create 17 queries others 8 and one page even makes 37 queries... I was planning on optimizing my website since many of these queries are created because of uncahed templates...

and I was wondering how much queries are the average "ok" number of queries for a page?

any feedback would be appreciated.

[Colin F]

How many queries are just too much?

On my site some pages create 17 queries others 8 and one page even makes 37 queries... I was planning on optimizing my website since many of these queries are created because of uncahed templates...

and I was wondering how much queries are the average "ok" number of queries for a page?

any feedback would be appreciated.
Generally as little as possible is the way to go. But there's no amount you can say that is perfect, as some pages just need more queries than others. 37 is too much for sure though!

Like you mentioned, a great idea is to precache all the uncached templates, as each of those adds an additional query.

[Xenon]

As Colin already said, you cannot say a definit value.

normally you say that you should stay below 25-30, but that's not always possible.

also think that sometimes three fast queries can be better than one slow.

[Polo]

thank you for the feedback guys... I will keep that in mind ;)

[Xenon]

you're welcome :)

[AN-net]

between 10-20 i find the most optimal going over 20 is starting to over do it....

[Polo]

Thanks AN-net, will keep that in mind ;)