I would like to know what would be the performance trade off in using a
INSERT INTO....SELECT ....(mass insert)
Loop the SELECT and INSERT statements (one insert at a time)
By looping a select stmt followed by a insert, I can see the benefit of issuing intermittent commits.
In terms of performance, how does the masss insert compare with a SELECT-INSERT loop ? Any article to read more on this topic.