We are prototyping an application that is inserting 500 rows into a
table. One method is to using batching and make one database call to
insert all 500 rows, the other method is to make 500 database calls
insert 1 row each time. The problem is that the batching method is
about 20% slower. Does anyone have any insights as to why this is the
case? I was expecting the batching to be faster.
DB2 9 on AIX 5.3 64 bit.
Thanks!