Cool hack buddy :)

- miSt

Is there any way this can be implemented for search.php (view new posts) as well? Most of our members use that, which, to say the least, generates a lot of unwanted load.

Thanks :)

Installed - here's hoping it works ;)

well for those tests these infos is not very helpfull, if you want to test differences between queries you have to use em in loops.

so compare to run 100 times the big old one with 100 times the small two new and you'll see the effects really :)

I've updated the instructions for search.php, usercp.php and member2.php :)

I noticed some differences in member2.php and usercp.php. You used dojoin instead of dotjoin. I guess it has to be dotjoin like the others, so I changed it in my setup. Can you confirm this as a typo in the textfile/instructions or does it have to be dojoin

- djr

you're right, this is a typo.
It won't change anything but $dotjoin is right ;)
I found this typo in the original member2.php too (2.2.9).

My Instructions have been updated once again.

pwr_sneak: You rule sir. Thank you :)

good find, however my forums are still slow with dot folders :(

this has decreased the load time though...

Interesting... :) Another example of how 2 queries sometimes can be better than 1. :)