Re: JDBC addBatch more efficient?

Поиск
Список
Период
Сортировка
От David Wall
Тема Re: JDBC addBatch more efficient?
Дата
Msg-id 480CB299.4050409@computer.org
обсуждение исходный текст
Ответ на Re: JDBC addBatch more efficient?  (Ivano Luberti <luberti@archicoop.it>)
Список pgsql-general
> Does this means that the two features are independent one from each
> other ?
> In other words, can we say that JDBC batch will limit information
> exchange between client and server while Postgres prepared statements
> will optimize their execution ?
I've not used it yet, but my impression is that you can use
PreparedStatements (in a loop typically), often surrounded by jdbc
transaction commit so each statement doesn't run in its own
transactions, do an addBatch and then submit that so all of the
statements are executed by the server as a group.  So in this case, yes,
they should be independent of each other.

David

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: pg_bulkloader (was Re: In the belly of the beast (MySQLCon))
Следующее
От: "Pau Marc Munoz Torres"
Дата:
Сообщение: Re: help with "plpgsql"