> Hi, I have a query which retrieves 50,000 rows from a table where
> the query includes about 6 joins to various tables. When I run this
> in IBexpert it completes instantaneously.

> However when I run it in java it takes 6.6 seconds. Can anyone tell
> me what takes so long? The database is nice & fast, so is it maybe
> the JDBC driver, or more likely processing & putting the cursor into
> the java ResultSet?
> 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?

Roman