--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> > However when I run it in java it takes 6.6 seconds. Can anyone tell
> > me what takes so long?
> > Any profiling tips or any other ideas?
>
> When the query is executed in auto-commit mode, the result set is

fetched to

> the client before the executeQuery returns. Is it your case?

Yes, the connection is in auto-commit mode... some things have changed
a bit and the time taken is now 4.8 seconds. When I turn off
autocommit, time is 2.0 seconds.
While this is a vast improvement, this part of our code is executed
often, so 2 seconds is noticeable... can you tell me more about the
(default) fetch size (or a URL describing it)? I saw your follow-up
which said the requested fetch size is not guaranteed, but maybe I can
at least tweak it a little...?

Thanks very much
Phil