Delay closing resultsets
Fernando Lozano
fsl at centroin.com.br
Fri Sep 29 21:32:37 EDT 2000
Hi there!
I am using the freetds jdbc driver for an application that queries
MS SQL Server 7 on a WAN. My application requires searches that
returns thousands of rows such as like 'name%' queries.
Most of the time my users will see the first dozens of rows and then
quit to a more refined search, but it looks like the freetds jdbc
driver conties to fetch all rows when I close it. The result is a
big delay (which can be of several minutes) when the user wants to
try another search. Using Connection.cancel() has the same result.
Is this a bug of the driver, some feature not yet implemented, or
what? The only workaround I got so far is to call
Statement.setMaxRows(), but this way the user won't be able to see
all results, and this is not desirable.
Any hints will be very apreciated.
[]s, Fernando Lozano
More information about the FreeTDS
mailing list