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? :D

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.

Anyone out there anymore? :D

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

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.. :)

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

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

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 :p

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

this file should work with filberts Optimisation

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?

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

Not a problem.. I suppose if noone can help me, I could reverse all the steps in Xenon's hack and do filburt's first if that worked for you but I would prefer not to...

filburt1? Xenon? Help! :D

lol yeh i know what u mean i really dont like hacking files but i enjoy the results
lol i added so many hacks that my forum homepage had too many queries

so least its not too bad now :D

ps i like your forum very nice erm wondering wha it would be like for 56k users :P

cuz i know my forum is a bit graphic heavy aswell

This hack seems to have made my moderator list dissapear :cry:

great hack!!!!

went from 18 to 15 queries on my index page :)

G/J

BTW..i install Xenon's hack after i got install this and it went down even more.....from 15 to 12 :D

I have noticed that using the SHOW TABLE STATUS query in this manner produces different results for threads, posts and users that if you do it the standard way.

For example, doing:

SELECT COUNT(*) AS count FROM post;

Produces a different result for me than doing:

SHOW TABLE STATUS;

And looking at the "Rows" column.

I am curious as to why this is. Anybody know?

Nice ^__^

Page generated in 0.44381301 seconds (89.90% PHP - 10.10% MySQL) with 18 queries.

Was 23 queries :)

Hi @ll
This modification works with version 2.3.4?

thanks