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

[James Palmer]

For consistency, here is my response to your question on ProgressTalk: Be aware that large transaction is generally bad practise. You want your transactions to be tight and quick. If you're updating a lot of information with a chance the transaction might roll back then obviously the system has to keep a track of this. Your BI will grow, and you'll probably run into lock table overflows. An all or nothing approach like you describe needs some very careful thought and should only be used where absolutely necessary.

Continue reading...