Skip to Content
0
Apr 08, 2014 at 07:12 PM

Auto commit for inserts

899 Views

Hi experts,

I have a procedure that is writing a lot of INSERTS into a table one at a time and I noticed the inserts are not truly committed until after the procedure has completed successfully. This is ok when running for a small amount of data but I'm concerned if I start running larger volumes of data that this will become a memory issue. Is there a way to force the inserts to commit after each insert?

Thanks,

-Patrick