Re: Multiple Row Insert vs. Batch

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.
>>
>
>