Transactions (system.db)

Is there a way for ignition to prevent two transactions from going at the same time.
example
two clients make the same exact action(executing a DB transaction, the same transaction) , at the same exact time( I know it’s almost impossible for this to happen) , but if it did happen, is there a way to make ignition give one first , wait for the transaction to be committed, and close and then execute the other one?

No, but you should be able to constrain the DB to reject the 2nd transaction. Or even better, arrange for those transactions to run from gateway threads where you can interlock them.

1 Like