brownie124
Programmer
Hi,
If I am inserting millions of records (in small batches of 5000 at a time), would I get any measurable performance gain by doing these in a transaction and committing the 5000 all at once as opposed to inserting one at a time. The records themselves are relatively small, 3 columns, 1 primary key and one additional indexed column.
Thanks,
- Michael
If I am inserting millions of records (in small batches of 5000 at a time), would I get any measurable performance gain by doing these in a transaction and committing the 5000 all at once as opposed to inserting one at a time. The records themselves are relatively small, 3 columns, 1 primary key and one additional indexed column.
Thanks,
- Michael