Hello Nico,

NC> You know what is funny : when I first execute that SQL statement in
NC> IBExpert, and then I open my application, there is no delay, it's
NC> fast immediatly ...
That's one more sign that what you see is a server-side caching. If
you could post your query, definition script for related metadata and
the query execution plan, then probably people in this list could help
you with the query improvement (if the improvement is possible at
all).



--
Best regards,
Pavel Menshchikov
http://www.ls-software.com