At 05:08 PM 9/15/2001 +0200, Leos Urban wrote:

>I run query:
>
>This query runs 17 seconds. It is OK.
>FB processes have now allocated 32MB (4096 pagesize * 8192 cache) - it is
>also OK.
>But when I run the _SAME_ query again (in the same connection) I got the
>same result - 17 seconds.

Could you run another test. Using ISQL, collect the statistics for the
query. Run it twice and send us the results.

ISQL> set stats;


In general, InterBase does use a cache when it is available.


Regards,

Ann
www.ibphoenix.com
We have answers.