PostgreSQL JDBC - Blocking on SQL Execution

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Blocking on SQL Execution

logan@datacurrent.com

2005-10-31, 8:24 pm

Hello,

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!

Logan Bowers

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links