29 queries on Forumhome !!!
 

FireFly, I saw you managed to keep such a low number of queries, even having almost all the index.php hacks I have on my board... (and got problems to mantain below 40 qrs...) !!

What's your secret ??? :confused:

Thanks.

Yeah, he has really done a great job in minimizing queries. He should really join the vBB developer team. ;)

FF, could you share some secret with us ? :p

Or maybe he hard coded it to say 29 querys ;)

Goddamnit DWZ, stop telling all my secrets! :D

29 is not that low, I wish it was less, like 25 or so. I might take it down to 27 later today, I have some ideas... :)

For me it's low enough... :)
I though to OUTER JOIN some query...

But could you share some of your secrets about (just like the forum viewers on home...) or at least give us some precious trick ?

I'm very eager for mysql optimisation.... !!! And I absolutely need it.

As an O-T example, right now I multiplexed the getpermissions() function per each user against one forum, obtaining strange values after 4500+ queries in 18 secs.... Ehehehehhhh!
[do you remember our old thread / my old idea about a complete and more accurate permission buster ??? ]
:p

Hop'in you ! ;)
Thnx

Thnx
:p

You just quoted yourself...

*inconspicuosly bumps*

If you'd prefer, I could quote the above (post #6) question... nobody answerded...
:p

There we go, 1 down, 28 more to go! :D