Re: Non-blocking SQL Execution

Ah yes, I like this strategy, it will actually make things easier in my
application for dealing with timeouts and such (since they can be
handled in the thread). Thanks!

Logan Bowers

________________________________

From: Dave Cramer [mailto:pg(at)fastcrypt(dot)com]
Sent: Monday, October 31, 2005 4:50 PM
To: Logan Bowers
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Non-blocking SQL Execution

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