Re: Inserting a large number of records

Поиск
Список
Период
Сортировка
Искать
От
Oliver Jowett
Тема
Re: Inserting a large number of records
Дата
Msg-id
42D67F4E.20204@opencloud.com
Ответ на
Список
Дерево обсуждения
Inserting a large number of records Greg Alton <greg@cfdev.com>
Re: Inserting a large number of records Oliver Jowett <oliver@opencloud.com>
Re: Inserting a large number of records Steve Wampler <swampler@noao.edu>
Re: Inserting a large number of records Oliver Jowett <oliver@opencloud.com>
Re: Inserting a large number of records Dave Cramer <pg@fastcrypt.com>
Re: Inserting a large number of records Dave Cramer <pg@fastcrypt.com>
Greg Alton wrote:
> What is the most efficient way to insert a large number of records into
> a table?

I use a PreparedStatement INSERT and addBatch() / executeBatch() with
autocommit off and no constraints or indexes present.

-O
В списке pgsql-jdbc по дате отправления
От: Greg Alton
Дата:
От: Steve Wampler
Дата:
FAQ