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.
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 ). 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.
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.
04-03-2003, 06:43 PM
34 of em
). 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. 
Linear Mode
