Optimize forumhome, the filburt1 Way

This hack greatly reduces the number of queries on forumhome. On my test board, before:

Page generated in 1.81393003464 seconds with 30 queries,
spending 1.17402160168 doing MySQL queries and 0.639908432961 doing PHP things.

After:

Page generated in 1.37496697903 seconds with 20 queries,
spending 1.00117218494 doing MySQL queries and 0.373794794083 doing PHP things.

The very, very clever hacker can combine elements of this hack and Xenon's to reduce forumhome queries even more; specifically, his optimizations for a moderator cache and Who's Online.

There's also an added benefit: since the number of rows in all tables are cached and not just users, posts, and threads, you can use $counts[tablename] anywhere in forumhome and have the number of rows in tablename show up (for example: Mail Messages: $counts[mailmessage]).

Note that because some PM processing is now given to PHP instead of MySQL, the page load time might increase. It will depend on how many PMs the current user has, among other things. However, the PM handling eliminates two queries.

[Alien]

Maybe someone can help me with a little step by step in getting this hack and the one by Xenon to work perfectly together? I attempted to merge the two together myself and it hasn't worked with multiple attempts.

Has anyone done this properly and can say specifically what to leave out of one hack or another to get them to play happily in the playground together?

Note: I have Xenon's hack installed already, and want the best parts of this hack to work nicely with it! Thanks for any help you can provide. This is the last thing I have to get past to go live with v3 of my site.

[Alien]

Anyone out there anymore?

[Alien]

Can anyone give a step by step on how to accomplish this?

[Oblivion Knight]

Sweet deal.. Brought my queries down from 23/24 on forumhome to 19/20, and everything appears to still be running ok. The load appears to slightly depend more on MySQL than PHP than it did previously (before: 80% PHP, 20% MySQL - after: 75% PHP, 25% MySQL), but that's nothing major.

Nice optimizing there filburt..

[Alien]

I'd still like to get this to cooperate nicely with Xenon's hack, can anyone help with my post above?

[Alien]

Can anyone help with a small step by step in making these 2 work perfectly together?

[msimplay]

old
Page generated in 0.13271797 seconds (85.62% PHP - 14.38% MySQL) with 37 queries.
[Debug Mode OFF] [PHP v4.3.2] [GZIP enabled - level 1] [Server Load: 0.54 ? 0.61 : 0.92]

New
Page generated in 0.1300003 seconds (72.34% PHP - 27.66% MySQL) with 32 queries.
[Debug Mode OFF] [PHP v4.3.2] [GZIP enabled - level 1] [Server Load: 0.77 ? 0.63 : 0.90]

Basicly 37 down to 32 queries the forums gone blazing fast
on a really hacked forum ie 80+ hacks

erm wondering now can i still add xenons hack

but am wondering why server load has increased :s
and its going faster

[msimplay]

08-05-03 at 05:15 PM Alien said this in Post #46
Can anyone help with a small step by step in making these 2 work perfectly together?

this file should work with filberts Optimisation

[Alien]

Unless you edited that file, I already have Xenon's hack installed as it was out first. I want to add this one for the additional 1-2 queries more that I can save but need a step by step on how to do this and I'm surprised noone has followed up on this.

It's not a simple matter (as I was hoping) of just modifying stuff in the usual way (and just not replacing one thing that both modify etc.). It seems more complicated than that when i started finding/replacing stuff so I quit it.

Can anyone help with a simple STEP-BY-STEP on this?

[msimplay]

i'm sorry i did in reverse to u i added Filberts hack first then i added Xenons hack afterwards like that