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 avoided after every insert.
My question is: Are they any known side-effects or drawbacks of using multiple inserts. I am aware the error checking is much more difficult in the second approach. Any other drawbacks?