Non-blocking SQL Execution

Поиск
Список
Период
Сортировка
От Logan Bowers
Тема Non-blocking SQL Execution
Дата
Msg-id 85CE4E3FD2EC2C4E8AAE39916AC1A383090BA842@ms07.mse2.exchange.ms
обсуждение исходный текст
Ответы Re: Non-blocking SQL Execution  (Dave Cramer <pg@fastcrypt.com>)
Список 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 по дате отправления:

Предыдущее
От: logan@datacurrent.com
Дата:
Сообщение: Blocking on SQL Execution
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Non-blocking SQL Execution