- Jan 17, 2015
I didn't really mean to dismiss the relevance of extremes; obviously 1000 queries is nuts. However, I think it's silly to complain when an add-on performs, say, two or three additional queries per page. If it's displaying data, it's probably going to perform queries--and even if it could technically avoid those queries, it might be worse off.This is just wrong. Of course its a metric you should be worried about.
It might not be the only metric too look at, but to say its not important is just nonsense.
If your page is running 1000 queries then something is wrong - regardless of how "optimised" they are.
My statement isn't wrong: in general, you shouldn't be worrying about the number of queries; you should be worrying about the time your queries take to complete, both in aggregate and individually. If you have 1000 queries, that time is going to be unacceptable anyway, so there's no need to fret over the number of queries unless you already know something is wrong. Complaining about an additional two queries per page doesn't make sense when they're probably taking something like 1ms combined.