Incremental Commit on Large Insert
637170May 1 2008 — edited May 1 2008Hey guys, hope you can help me with this. My team and I are trying to insert about 150 million records from a query using 4 tables into 1 table. Due to hardware limitations, we need to commit ever n number of records. The best solution we have found so far is a loop that has an iteration counter, and commits when the counter is divisible by a certain number. However, that involves inserting rows 1 at a time, and slows down the insert dramatically. Anyone have any other suggestions to accomplish this? Thanks for your help.