Re: Multiple Row Insert vs. Batch

Поиск
Список
Период
Сортировка
От Vitalii Tymchyshyn
Тема Re: Multiple Row Insert vs. Batch
Дата
Msg-id CABWW-d1=T9jUQu+7wdc62vzuQ20Wkw2nRcXJcyXQK9pGPdZZHg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multiple Row Insert vs. Batch  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: Multiple Row Insert vs. Batch  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc

I think OP meant something like
Insert into table values (?,?,?),(?,?,?),...,(?,?,?);
Vs batch of insert into table values(?,?,?);

I really think first would be faster up to a certain amount of rows, but test is needed to check.

Vitalii Tymchyshyn

Сб, 6 черв. 2015 13:30 Dave Cramer <pg@fastcrypt.com> пише:
batch should be faster and if it isn't we did something wrong

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 6 June 2015 at 12:34, Robert DiFalco <robert.difalco@gmail.com> wrote:
Say I need to insert 250 rows. Is single-statement multiple row insert or JDBC batch likely to be faster?

Thanks!

R.

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Multiple Row Insert vs. Batch
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Multiple Row Insert vs. Batch