Neil Conway wrote:
>
> On Tue, 2002-03-19 at 19:20, F Harvell wrote:
> > I feel that the caching should be SQL transparent. If it is
> > implemented reasonably well, the performance gain should be pretty
> > much universal.
>
> Well, the simple query cache scheme that is currently being proposed
> would use a byte-by-byte comparison of the incoming query. I think the
> consensus is that for a lot of workloads, this would be a bad idea.
And this is what I have been trying to argue. Many SQL deployments execute a
set of hard coded queries as the majority of the work load. The dynamic
queries, obviously, will not be cached, but the vast majority of work will come
out of the cache.
