If the connection is in autocommit, then each statement will also incur a
commit (write to the commit log on disk).
On Fri, Sep 23, 2016 at 2:01 PM, Rakesh Kumar
wrote:
> Hi
>
> I am noticing that if I do this
>
> insert into table values(1,a)
> insert into table values(2,b)
>
> insert into tabl
Hi
I am noticing that if I do this
insert into table values(1,a)
insert into table values(2,b)
insert into table values(3,c)
commit after 500 rows
it is lot slower (almost 10x) than
insert into table values((1,a),(2,b),(3,c)) .. upto 500
It is obvious that the gain is due to network trip a
