What is bringing your server to it's knees? I'm using it on 2 million+ forum with no problems.

If you are going to have that attitude then I don't need to bother posting things like this but if it makes you happy I can post it in the bug tracker. I'm sorry that you feel I'm trying to "hide" something. Perhaps if that was my goal then I would have just updated the code and not posted here at all? Doesn't that seem to make more sense?

well whatever ;) thanks for releasing it here freddie im sure alot of people appriciate it including me :)

nice one Freddie :)

that shows the little hints can boost MySQL :)

IMO Freddie's first post was accurate and straightforward - it's an optimization for vB3 from the upcoming 3.0.2 release. Since adding it involves editing a file, and it's not a bug, this seems to be the appropriate place to release it. Of course, there are other possible ways to look at it, but the majority here seem to appreciate it as do I. Thanks again Freddie!

Any other tidbits you can throw our way? :D

Funny - my speeds increased with this hack.

getnew went from .02 to .03

getdaily went from .05 to .07

and my get unanswered threads went from .30 to .44

-Michael

WoodiE that isn't possible unless you ran an unscientific test or you are missing the index on the thread table.

Kick ass. Thanks a LOT, Freddie! Doing nicely...

Ignore the naysayers... THANK YOU for releasing this early; makes a huge difference on sites with 1 mil+ posts.

thanks Freddie ...

optimization hacks/tip = :D:):up: