is to much for a normal server

I have about 59 queries running for forumhome

Did you counted all the select query's or?

59 is a lot... we have 33 but that's only because we got lots of info/stats queries going on.

What do you have installed?

<!-- Page generated in 1.7976969480515 seconds with 131 queries -->

:surprised

I think this may be a lot of queries then? Should I reduce it?

My forumhome:

Page generated in 1.7976969480515 seconds with 131 queries

Too many do you think? *shrug* I have no idea, but you guys are saying 59 is a lot...

IDK, I just did &explain=1
and stated what the results were

the other pages are fine, with around 20-30, but the main page has 59, I really don't know what could be causing this??

If you want you can take a look at www.ochroma.net/forum

What hacks do you have installed, Psychdrone? I see a lot of queries that get access masks data but I still don't think they are there in the vanilla vB.

Martz, you are in even deeper s***! :o

lol
Powered by: vBulletin Version 9.1.1
in ochroma forum

Matrz, you've got some seriously jacked code. You really should re-think how your pulling your data.

I have 18 query's

What are "queries"? What do they do? How do they run? What are their purpose? Just some ?'s I have cuz I have no idea what you guys are talking about heh :)

Queries are calls to the DataBase requesting information. Generally speaking, the fewer you use, the faster your scripts will run.

Hrmz, I think it the number of queries shot through the roof for the users-online today hack.. :(

I'll take a look.

Nope, because we also have that hacks installed and it only adds one more query.

You probably have a query instide a loop, when it should be outside....

hmm what about this Fly, I have it so that it shows the subforums on the main page, would that require a seperate queriy for each one?

hmm thats the only thing I can think of that would add a lot, I'll keep on looking thu, if thats not it

and yes thank god I am not in the deep **** that Martz is in:D

Yes Psychdrone, that's part of your problem. (see file)
Remove that hack...

I can only guess the access queries are part of vBulletin 9.1.1.

How do you find out how many queries are on a page?

I see the &explain=1. But where is this run? You know I'm a n00b at this.

Huh? Just add the explain variable and scroll to the end of the page.
You can even call it without a value, i.e &explain= so you don't get all the technical stuff.

I must be an idiot.

Replace & with ?.

Thanks :)

hehe;)

man that hack sucks! Maybe Firefly, you should put a request on so people will inform how many quiers if any, wil be added to the page.....?

if you look at the queries, it's running inside a loop changing the value of parentid. That could probably be added to the query outside the loop in a JOIN clause.

You can also re-write that hack in a similar fashion to how the actual page is displayed. Write a function called getsubs() that gets a $parentid, then goes through the cache of the forums displaying names of all forums with that $parentid.

Yes, I suppose you could, FireFly. Couldn't you? ;)

wow that changed my quiers from 59 to 27!

YIKES, thanks Fire;)

holy $h!t :eek:

mine has 30 queries on forumhome but i'm using 2.2.0

Page generated in 1.2088500261307 seconds with 30 queries,
spending 0.75153636932373 doing MySQL queries and 0.45731365680695 doing PHP things.

.5 seconds for an extra 101 queries isn't bad though :D

Page generated in 0.39263999462128 seconds with 23 queries,
spending 0.062354683876038 doing MySQL queries and 0.33028531074524 doing PHP things.

Another hack which i noticed took up alot was the last topic title on forumhome that gets the icon as well, for every forum there is a query to the icon table + the thread table to get the title and icon. Mine just stores it in the forum table so it doesn't increase queries.

Forum Homepage:

Page generated in 3.5857490301132 seconds with 100 queries,
spending 3.0074957609177 doing MySQL queries and 0.57825326919556 doing PHP things.

Largest Forum's forumdisplay page:
Includes five sub-forums, over 60,000 posts.

Page generated in 0.53195905685425 seconds with 22 queries,
spending 0.29055750370026 doing MySQL queries and 0.24140155315399 doing PHP things.

Thread with over 130 Replies in that largest forum above:

Page generated in 0.95708394050598 seconds with 109 queries,
spending 0.23254978656769 doing MySQL queries and 0.72453415393829 doing PHP things.

Tim Wheatley, this is not a contest. ;)

Oooohhhhhhhh yes it is ;)

Life is ony big contest :D

haha :D

i just installed 2.2.2 with some stats:

Page generated in 3.4783860445023 seconds with 41 queries,
spending 2.6836801767349 doing MySQL queries and 0.79470586776733 doing PHP things.

For those who installed the Sub-Forum hack, it will add many queries, one for each forum and for each sub-forum. You can eliminate the sub-forum queries if you have no private/hidden forum under a public forums. Details are in the sub-forum hack thread.

Page generated in 0.16160094738007 seconds with 24 queries,
spending 0.077735185623169 doing MySQL queries and 0.083865761756897 doing PHP things.

I guess i'm safe :)