Re: JDBC addBatch more efficient?

Поиск
Список
Период
Сортировка
От David Wall
Тема Re: JDBC addBatch more efficient?
Дата
Msg-id 480CACEF.7000208@computer.org
обсуждение исходный текст
Ответ на Re: JDBC addBatch more efficient?  (Kris Jurka <books@ejurka.com>)
Список pgsql-general
> The JDBC driver's batch processing is more efficient than regular
> execution because it requires fewer network roundtrips so there's less
> waiting.  The JDBC batch is broken into an internal batch size of 256
> statement and all of these are sent over to the server at once.

That's great, Kris.  I  believe our code only does 100 updates/deletes
before committing the transaction anyway, so this should work well for us.

Thanks,
David

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

Предыдущее
От: zedware
Дата:
Сообщение: Re: How to tell if 64 bit vs 32 bit engine?
Следующее
От: Ivano Luberti
Дата:
Сообщение: Re: JDBC addBatch more efficient?