Subject Re: [Firebird-Java] SELECT FIRST issue
Author Roman Rokytskyy
Hi,

> As this loop is executed lots of times, this increased response time is
> quite significant in my application performance.
>
> Does anybody know what could be happening?
>

Can you provide a small test case to show the problem?

Very likely what you see has something to do with the garbage
collection, basically the Firebird engine is collecting the garbage
while looping through the result set, but in order to tell this for sure
I need to see the source code.

Roman