I'm running a web application that needs to run several queries against
several databases to satisfy a single request. To minimize latency I'd
like to be able to issue "<PreparedStatement Object>.executeQuery()" on
each connection, allow the servers to execute the queries in parallel, and
then only block when I attempt to fetch the first row.
My anecdotal experience with JDBC drivers in general are that they block
when you attempt to execute the query, not when you attempt to retrieve
data. Is this the case for the Postgres driver? Does anyone have a feel
for how hard it would be to modify the driver allow queries to be executed
in the background? Thanks!
pgsql-jdbc by date
|Next:||From: Logan Bowers||Date: 2005-11-01 00:06:45|
|Subject: Non-blocking SQL Execution|
|Previous:||From: Kris Jurka||Date: 2005-10-31 23:00:49|
|Subject: Re: translation update: pt_BR|