[Info-Ingres] Hard query is in the way of next query

[Cecil Westerhof]

We are using Ingres Linux Version II 3.0.2.
I was asked to optimize some queries that where using views. The queries
took up to 12 minutes to execute. I rewrote them not using views and the
new queries execute in around 1/3 of a second. Not bad indeed. ;-}
To show the change I wrote a script that for each query execute the old and
new one severall times and display some statistics. The strange thing that
when I run then new query after the old query, the new query can take up to
7,5 seconds to execute. Even when I put a sleep for 5 minutes between the
queries. In this way I do not get a good statistic. What is happening here
and what can I do about it?