Optimize forumhome, the filburt1 Way
 

This hack greatly reduces the number of queries on forumhome. On my test board, before:
After:
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.

hey if i sent u my index.php wood u b able 2 gib us a hand optimising ? my index.php is hacked up :(

i hav 26 queries on forum home

Interesting idea. I don't have Xenon's hack installed, but I am using Tigga's Forumhome Stats cache. Care to add the moderator's cache and online users cache? ;)

Nice filburt:)

[high]* assassingod clicks install[/high]

Sorry but you're not allowed to send people full vB files (not that I don't get them every now and again :p).

Odd.. I tried installing this and it actually increased the page load time. I already have Xenon's hack and my Stats Cache installed, so I wouldn't really see the benefits for parts of this. It seems to be coming mostly from the PHP code that gets the private message info...

Before
Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND messageread=0 AND folderid=0
Time before: 0.19265496730804
Time after: 0.22409498691559

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 1947 Using where

--------------------------------------------------------------------------------

Query: SELECT * FROM statscache
Time before: 0.2369509935379
Time after: 0.23781204223633

After
Query:
SELECT privatemessageid, messageread, dateline, folderid
FROM privatemessage
WHERE userid = 1
Time before: 0.28443694114685
Time after: 0.32564997673035

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 1947 Using where

--------------------------------------------------------------------------------

Query: SELECT * FROM statscache
Time before: 0.50849199295044
Time after: 0.54340195655823

nice hack filburt, i see some really nice things in it.
but the PM query, i think it would take longer if a user has more PM's stored, so i think here your way will increase the load of the system more than it saves...

edit: also the newest member part ist slower than the original way i think, here would help a cache (like on vb.org ;)) more i think

True, it's a tradeoff: one query instead of three for PMs, but the processing is handed over to PHP instead.

I'm morally opposed to caches, they're a PITA to update :p

i like caches if i can use them without to much problems ;)

yeah one query instead of three is better this way.
but i know from my first version where i had one query for pming it was much slower than the old three, when a user has had a lot pm's that's why i used my compromis of two queries ;)

nevertheless, i'll see if i can use some of your ideas here ;)

Good point. I have over 2,300 PM's saved right now. When I logged in with a test account though it did seem to speed the generation time up by just a little. Because of the other hacks I have installed though it only saves one query and the page generation time doesn't seem to be enough to warrant installing it (plus I don't want to slow the generation time down for myself :p). Either way though it's still a nice idea filburt. :)

The cache-meisters :)

I'd love to see showthread.php's queries reduced :)

- miSt

Tigga and xenon, which parts would be ok to use then? ;)

@Boofo: you can use everything, the pm thing i'd suggest to use mine, but the other stats are good by filburt.
it depends also a bit on your board, what you have optimized already ;)

Right now, I have Tigga's Forumhome Statscache installed. I had your hack installed but had to remove it when I couldn't get the browsers hack working with it. ;)

boofo that was version 1 of my hack, version 2 has no problems with any hacks :)

you should use some parts of mine and others by filburts to get an optimum :)

Your version 2 works with the countbrowsers on forumhome? I didn't know that. I will have to use it now. Will it work ok with Tigga's hack or do I need to uninstall that one first and then re-install it after I install yours?

Nice filburt!:)

Got my forumhome (on a new site) down from 22 to 16:)

Satan

I have Xenon's excellent hack installed. No other forumhome optimizations are installed.

What parts of this specifically should I install that will benefit me? I got myself down to 19 queries and would love to move it down further! :D I'd also like to skip out on the PM optimization, I'd just like to use whatever else that isn't a part of Xenon's hack.

-Jason

Nice hack.
Thanks filburt.

thx installed the hacksucessfully

from 26 to 22

nice. from 22 to 17.

l8er
sonic

17? Very sweet. I already have 22 on mine with no optimization except my own, but I don't use caching. Just modifying code, and removing things I don't need, like the moderator query (did you know that you can take that away if you don't have a moderator column?).

But if you have the Miderators listed like they do here on vb.org (Moderated By: ), you still need it right?

for now, yes, but i'll remove it soon ;)

that's where i like my hack ^^

But you will still have the "Moderated By:", right?

I went from 20 to 13, but the members, posts, and birthdays act wacky so I'm putting it back :(

I went from 20 to 13, but the members, posts, and birthdays act wacky so I'm putting it back :(

how would i accomplish that? would it simply be a case of removing
from the index.php file, or are there other bits that i've missed? i already have removed the mod columns on forum home etc etc

many thanks in advance :)

just remove that part yes :)

thank you very muchly, one down, now at 27. i'm thinking about using filburts mods to lower it some more still.

???

You just edit the template... is that what you mean?

another nice hack from u!

greetz Sebi

*install*

Do I still need the moderator cacheing code in the index.php for the Moderated By: ?

If you want it like vb.org you must cache the mods in the forumtable (my hack) or use the standart method ;)

Anyone have any ideas on this? :)

https://vborg.vbsupport.ru/showthrea...746#post400746

as i already said, you can use every line of filburts hack which doesn't modify the same codeblocks than my hacks and they'll work together perfectly :)

Okay just wanted to be extra careful not to break anything. :)

I'll give it a whirl!

Filburt - it's fantastic!

excellence!!!!! my forumhome is loading great, along with showthread!!! YAY!!! ....sadly, the forumhome stats hack by TECK ( i think :o ) doesnt work on my forums :( *cries*

mine is pretty good. I have 305 PM's.