Re: Multiple Row Insert vs. Batch

Yes that's correct. A multiple row insert with a single insert statement. I'll try benchmarking the two on Monday. My guess is that they are pretty damn similar.

Sent from my iPhone

> On Jun 6, 2015, at 10:35 AM, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>
> Robert ??
>
> Is that what you meant ?
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>> On 6 June 2015 at 13:34, Vitalii Tymchyshyn <vit(at)tym(dot)im> wrote:
>> 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.
>