Does this mean that the fetch size is ignored in the default auto-commit
connection state?
BTW, what is the default fetch size?

Thanks, Rick DeBay

-----Original Message-----
From: Roman Rokytskyy [mailto:rrokytskyy@...]
Sent: Thursday, July 29, 2004 3:07 AM
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] Speed problem retrieving 50,000 rows...

> 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