Clinton Begin wrote:
Hey Vic,>>When doing large inserts in loops; for performance it's best to have the >>commint/rollback and start batch outside of the loop?Yes, absolutely. Not only for performance, but otherwise it wouldn't be "a" transaction would it? :-)
THX! .V
