At 01:52 AM 2/9/2003 +0000, dvanatta <dvanatta@...> wrote:

>Does Firebird have anything like the MySQL Query Cache?
>
> >From the MySQL website:
>
>What is the MySQL Query Cache?
>Query Cache is an intelligent MySQL feature, which allows to greatly
>improving the speed of the frequently executed queries by caching
>query response and returning it to the client instead of real query
>execution.

That feature makes a great deal of sense if you have queries
that always return the same results set and can determine
cheaply whether two queries are the same. Remember, until their
latest release, MySQL didn't have prepared queries, so it was
very easy to determine whether two queries were actually the
same.

In Firebird, there are many subtle variants (e.g. you might be
referencing a view that uses a user name as part of its selection
criteria.) This is a feature the MySQL people like a lot, but
I'm not convinced it's applicable to Firebird.

Regards,


Ann