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?

TIA...
BTW, using Firebird 1.5, Java 1.4.2.