Forum Post: RE: how to rollback the transaction while system crash /sudden power shut down

[OctavioOlguin]

1,000,000? that's a huge transaction, some procedure I designed wrong some time ago, run out of resources near 5,000 records processed, in any case this is in theory what you should be doing: (the trick is the do transaction to widen your scope to catch all the process in one transaction, and the handling of roll back will be handled by database itself, transparently to you).. DO TRANSACTION: FOR EACH (onemillionrecords query): ... do_something_to_record..... END. END.

Continue reading...