Too Many Queries?

[The Finman]

Somewhere in these forums I thought I read that more than 10 queries for vB was too much (I believe the thread had a poster with 100+), and that the average number of queries shouldn't really be over 3.

I have on average about 13 queries (vB 3.6), and I noticed that vBulletin.org is averaging about 16 queries.

So, given that I have read most people having 20-30 queries, 13 doesn't seem that much.

My question is, did I mistakenly read somewhere that there shouldn't be usually more than 3 queries, and if I did then is 13 reasonable?

Thanks in advance.

~Fin

[SCRIPT3R]

i wouldn't want 100 queries on a busy (100+ highly active users) forum, but anything less then 15 queries should me more then fine. of course it depends on what those queires are, but on average, i think you're ok.

[Adrian Schneider]

It depends on the page, and on the queries.

If you have a ridiculous amount of queries (like 40+) you probably have them executing inside a loop which is in most cases unnecessary. 1 poor query could have far more server load than 100 efficient queries could ever have.

But with only 13, you have nothing to worry about.

BTW, every vbulletin page will start with 5 or 6, not including the content for that page. If the page has a lot of different content coming from different places (not all from a single table) then it may take many queries to pull the data correctly.

[The Finman]

Thanks SirAdrian & GearTripper for the fast reply.

I guess either I didn't read it correctly or I didn't remember it correctly.

I feel much better now. Again thanks