Quote:
Originally posted by nuno
Chen already said one query is slower, however, this only occurs when you have a considerable amount of PM's stored.
So, i think your assumption is not correct.
It is faster for users with few pm's.
|
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