300 queries in forum permissions?!

[Billy]

I don't know if there is any truth to this, but I was told somewhere that the forum permissions area in the admin cp took 300 queries with 8 forums and when adding more forums, the query count increases.

IS this true? Because I know that 300 queries to produce a page is NOT good.

[The Prohacker]

To see how many queries, add &explain=1 to the end of the url.

With the default one forum and one catagory I see 11 total..... And this is 2.0.3, so it could have improved by now, so I highly doubt 300 unless they have a crap load of forums....

[tubedogg]

The number of queries used to generate that page is as follows:
1 base query.
2*the number of forums you have.
1*the number of usergroups you have.

So say you have 8 usergroups (about standard) and 10 forums. 2*20=20 + 1*8=8 + 1 = 29. Nowhere near 300.

Admin pages are optimized heavily just as everything else is but sometimes there is no way around a lot of queries (update counters, for example). It is used because the Admin CP is not subject to the foot traffic that your forums are.

[eva2000]

Originally posted by tubedogg
The number of queries used to generate that page is as follows:
1 base query.
2*the number of forums you have.
1*the number of usergroups you have.

So say you have 8 usergroups (about standard) and 10 forums. 2*20=20 + 1*8=8 + 1 = 29. Nowhere near 300.

Admin pages are optimized heavily just as everything else is but sometimes there is no way around a lot of queries (update counters, for example). It is used because the Admin CP is not subject to the foot traffic that your forums are.

wow

let's see for me that would be

1 + (2 x 140 forums) + (1 x 14) = 295 queries

so billy i doubt having only 8 forums would amount to 300 queries unless you had 100s of usergroups

[Chen]

Originally posted by eva2000
wow

let's see for me that would be

1 + (2 x 140 forums) + (1 x 14) = 295 queries

so billy i doubt having only 8 forums would amount to 300 queries unless you had 100s of usergroups

[Kaizen]

How does your server take it!?

[eva2000]

takes it easily

171 queries/second on searchindex reindexing - check it out http://vbulletin.com/forum/showthrea...hlight=queries

remember that page isn't regularly accessed only when adding new forums or loading that page..

[Kaizen]

lol

you have to re--index overnight

hehehehhe

never taken me more than 20 minutes.

[eva2000]

yeah that's because i had 452,000+ posts 29,000 threads and wanted to reindex

with min 3 and max 17 characters

now i have 9+ million records in searchindex

also vB ain't the only thing on my server.. i have several live sites which get as much traffic or more than my vB forum

[Kaizen]

*me waits for eva's server to crash

*me thinks, not long now !!!

[Kaizen]

oh and btw

isn't your sig getting a little big

I got a pm the other day from some user asking me to shorten.

I agreed and did !

But yours just gets bigger everyday - lol

[eva2000]

LOL... my sig's a permanent fixture around here take a read http://vbulletin.com/forum/showthrea...threadid=23421

[Kaizen]

hehehe



btw you took the link out to calculate hits on pages

mysql hit counter or something

whats the link for that ?

Also:

I heard you were talking about english colleges/uni etc.

R u coming here for your education ?

[Billy]

Are you guys looking at the right place, he said there were 10 groups and 8 forums. He said in forumpermissions that it was 300 queries.

[Billy]

Oh, I don't know if this matters, but he said that some of your queries aren't counted in the count, so he added those to the count and that is where he got the 300 from.