where's the threshold of this considerable amount?
I do like those well scaling solutions more than those with unneccesary performance breaks.

I just wanted to say that it's not always good to run less queries than others do.

Maybe someone could figure out how many PMs are needed to make this one query slower than the original three.
My Database stores 1.3 million PMs and as I said before, the three queries are faster by factor 6 - 8

Exactly. :)
I would like to know this as well.:)

you are right here, it would be intresing to find out how much pm's are needed to slow down...

in all my tests the one query was faster, but i never had 1,3 million pm's which i think most of the admins won't have....
If you have such a great db and board the optimization is to diasble pm-queries at all...

the 3 pm-queries on index.php run 0.0068 seconds on my servers. no matter how huge the privatemessage table is since mysql doesn't have to read anything from disk or crawl through big B-Trees.

Vieln Dank Xenon!! ;)

Great Hack, now I only have 17 queries on my main page, nice!!

my queries where 63, they are now 19

:)
it's a good feeling and also a good motivation to get so much feedback, mainly positiv :)

i'm currently planing v2 of this hack, which will strongly optimize it, i hope it will be finished in two weeks

33 to 23 querries.

thank you very much.

Xenon, seems that this hack doesnt work with version 2.3.0 :(
I installed it and then the forums homepage doesnt load, please have a look at it, the hack is great and I want to use it on my 2.3.0 board ;)

PS: Cheers again for helpng me Saturday! :D

You're welcome seby :)

Hmm unfortunately, i don't have much free time, so i think i can't work on a new version of the hack.
Haven't taken a look at 230 yet.....

But i'll try to do what i can :)