Subject Re: [Firebird-Java] Re: Speed problem retrieving 50,000 rows...
Author Roman Rokytskyy
>> No idea. Fetch size only tells driver how many isc_dsql_fetch calls
> should
>> be made to fill the internal buffer. You can set it to 1 and this
>> will guarantee that isc_dsql_fetch will be called only once.
> oops, have just seen in the ResultSet and Statement interfaces the
> methods to set the fetch size... sorry about that question :-[

Probably I was not clear. Statement.setFetchSize according to the specs
should tell the driver how many _rows_ should be fetched. However Firebird
does not care about this, so we can control this only approximately.

Roman