Interesting - I've noticed this too
I did wonder if its the Linux buffer cache manager being over
aggressive about flushing...?
regards
Mark
Ernest E Vogelsinger wrote:
>I have a query that runs for 17secs for the first time. Now, when executed
>a second time, it consumes 270 msec. From the third execution it's running
>with 29 msec.
>
>However this only holds for the open connection. When connecting anew, it
>starts with 270 msec and drops to 29 msec again.
>
>Any clues about this interesting behaviour?
>
>
>
>