db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Harshad <harshad...@gmail.com>
Subject Re: Performance issue of derby using JDBC
Date Mon, 15 Dec 2008 17:34:43 GMT
Harshad wrote:
> These seem to have paid off; the actual query time
> (statement.executeQuery) is pretty fast : about 1 or 2 milliseconds.
> 
> But reading from the resultSet using APIs such as getString, getLong,
> takes about 250 ms or more!!

Forgot to mention; the query usually (99%) results in just a singe row. The 250ms is consumed
in just reading the data from that single row!


Mime
View raw message