From: | Vitalii Tymchyshyn <vit(at)tym(dot)im> |
---|---|
To: | Dave Cramer <pg(at)fastcrypt(dot)com>, Robert DiFalco <robert(dot)difalco(at)gmail(dot)com> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Multiple Row Insert vs. Batch |
Date: | 2015-06-06 17:34:01 |
Message-ID: | CABWW-d1=T9jUQu+7wdc62vzuQ20Wkw2nRcXJcyXQK9pGPdZZHg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)fastcrypt(dot)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(dot)difalco(at)gmail(dot)com> wrote:
>
>> Say I need to insert 250 rows. Is single-statement multiple row insert or
>> JDBC batch likely to be faster?
>>
>> Thanks!
>>
>> R.
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2015-06-06 17:35:09 | Re: Multiple Row Insert vs. Batch |
Previous Message | Dave Cramer | 2015-06-06 17:29:44 | Re: Multiple Row Insert vs. Batch |