| From: | "Logan Bowers" <logan(at)zillow(dot)com> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Non-blocking SQL Execution |
| Date: | 2005-11-01 00:06:45 |
| Message-ID: | 85CE4E3FD2EC2C4E8AAE39916AC1A383090BA842@ms07.mse2.exchange.ms |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2005-11-01 00:49:42 | Re: Non-blocking SQL Execution |
| Previous Message | logan | 2005-10-31 23:40:58 | Blocking on SQL Execution |