How many queries does your index page generate?
 

I have 23 queries with a few small hacks installed.
(76.00% PHP - 24.00% MySQL)

how do i find out WITHOUT INSTALLIN TECKS HACK b 4 u suggest that

19 (usually) with quite a few statistic hacks installed. I have it set so the statistics are only updated every 10 minutes though so that saves about 9 queries most of the time. ;)

:eek: 34 of em

Tigga, that is a great idea. Is it difficult to do?

It's not too difficult... The main reason I did it was because it was taking too long for my forum index page to load (ok, it was only taking 0.8 seconds or so, but that's still too long for me :p). Some of the queries took quite a while, so changed it to update a new table every 10 minutes, and then it simply pulls the stats from that table. It wasn't too hard to do, so I'll write up a quick install file and release it incase anyone else would like something like that. Check the Full Releases forum in about 15 minutes or so. ;)

Mine: stock vB + around 8

@Tigga: i did really the same here on vb.org :)

but you can't release it as a hack, because it's special to the hacks you alread have installed.

Xenon - That, along with your "Optimizing Forumhome" has been a lifesaver to my server I'm sure. :)

I'm not sure why you say I couldn't release it though... I went ahead and put it in the Full Releases forum and just included the stats that I have on my page as of right now, and noted that if anyone had any stats they would like added to the "cache" to let me know. There's not anything wrong with that is there?
I'll probably take it a step further a little later and set it where each statistic can be turned on or off in the Admin CP when I have a little more time... I just figured I'd release it as is for now since dethfire asked about it. :)

yeah i looked at your hack, nice way, and you can post it of course ;)
i just missunderstood something here ;)

Page generated in 0.16103995 seconds (61.23% PHP - 38.77% MySQL) with 22 queries.

Keep in mind, I'm running vBindex with some additional features. The only optimization I've done so far is combining the queries for the total thread/post counts and the new thread/post counts. I may do more someday. I'm finding it takes some ingenuity, though, now that I've been trying myself.

Page generated in 1.29580605 seconds (9.70% PHP - 90.30% MySQL) with 30 queries.

is it supposed to be using that percentagfe of mysql?

Fairly hacked index page, but well optimized.

Page generated in 3.65948606 seconds (26.53% PHP - 73.47% MySQL) with 22 queries.

normally on a good index.php it's 50:50
30 queries are a lot i think, you should try my forumhome optimization hack :)

Page generated in 0.36133397 seconds (31.76% PHP - 68.24% MySQL) with 37 queries.

... i have way too many. I really should sort out my forumhome XD

forumhome:
=========
Page generated in 0.11878395 seconds (86.84% PHP - 13.16% MySQL) with 16 queries.

Page generated in 0.11697602 seconds (79.50% PHP - 20.50% MySQL) with 22 queries.
[Debug Mode OFF] [PHP v4.3.3] [GZIP disabled] [Server Load: 0.01 » 0.01 : 0.01]

At vB.org running vB3:

Page generated in 0.39780 seconds with 11 queries [Server Loads: 0.53 » 0.50 : 0.52]

and that value is just for Staffmembers ;)

I feel so special ;) - notice the time though - my index.php on vb2 loads far faster with 21 queries :)

Well,

My localhost has

About 200+ Queries just on frontpage

Page generated in 0.17895305 seconds (79.95% PHP - 20.05% MySQL) with 26 queries