Transactions and IDO Methods

IDO methods can be run within the context of a transaction. To reduce transactional overhead and blocking, you can set a method to run without a transaction.

Methods that do not update data in the database can likely be run without a transaction. A method that runs a long time in a transaction, potentially blocking other transactions, may perform better if it is run without a transaction. You can control the size of individual transactions by starting them and committing or rolling them back within a stored procedure.

To set a method to run within a transaction, select the Transactional check box on the IDO Methods form. At run time, the method starts a transaction before the stored procedure is called.

To set a method to run without a transaction, clear the Transactional check box. The method does not start a transaction before the stored procedure is called.