Postgres Pro
Downloads
Home   >   mailing lists

Re: Non-blocking SQL Execution - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Non-blocking SQL Execution
Date
Msg-id C0FA2AAC-0091-43DF-92AA-1AD5FF9105BD@fastcrypt.com
Whole thread Raw
In response to Non-blocking SQL Execution  ("Logan Bowers" <logan@zillow.com>)
List pgsql-jdbc
Tree view
It's probably easier to create a non-blocking thread which encapsulates the driver

And yes, the postgres driver blocks on the execute.

Dave
On 31-Oct-05, at 7:06 PM, Logan Bowers wrote:

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 Bowers"
Date:
Subject: Non-blocking SQL Execution
Next
From: "Logan Bowers"
Date:
Subject: Re: Non-blocking SQL Execution