Re: Multiple Row Insert vs. Batch

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