Non-blocking SQL Execution - Mailing list pgsql-jdbc

From Logan Bowers
Subject Non-blocking SQL Execution
Date
Msg-id 85CE4E3FD2EC2C4E8AAE39916AC1A383090BA842@ms07.mse2.exchange.ms
Whole thread Raw
Responses Re: Non-blocking SQL Execution
List pgsql-jdbc

Hello,

 

(sorry if this comes through twice)

 

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

 

pgsql-jdbc by date:

Previous
From: logan@datacurrent.com
Date:
Subject: Blocking on SQL Execution
Next
From: Dave Cramer
Date:
Subject: Re: Non-blocking SQL Execution