Re: Multiple Row Insert vs. Batch

I did a benchmark and multi-row insert with a single statement is about
6-7% faster than batch insert. This is for 250 rows executed a thousand
times in a loop (alternating between the two to reduce subsequent table
insert index slowdown). So a little faster but not significantly so.

On Sat, Jun 6, 2015 at 12:07 PM, Robert DiFalco <robert(dot)difalco(at)gmail(dot)com>
wrote:

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