Jeremy Andrews wrote:
On Thu, 2009-08-13 at 07:50 -0700, Earl Miles wrote:
The blocks can be cached.
Caching is great, but it shouldn't be an excuse for unoptimized code.
What does this mean? Are you saying that because generated queries are
by default unoptimized they should not be used? I really don't
understand what your point is here.
Simply (and generically) that a cache should not be justification for
slow queries.
I wasn't justifying a slow query, I was commenting on using the cache to
offset the additional overhead of actually building the view. I have no
illusions that building a query takes the same amount of time as having
the query. Neither should we be under any illusions that from a purely
performance perspective, a generated query will be as good as a properly
tuned query.
That said, individual views can be tuned to generate nearly identical
queries, it's just that it doesn't happen in a vacuum. You have to
intend to do it and know enough to do it.
We make performance to flexibility tradeoffs all the time, so implying
that performance should be the only consideration is also wrong.
