Is transaction NO AUTO UNDO possible/useful?

[kneighbour]

I am using Firebird 3 with UniDac and Delphi XE7. I am looking to speed up the interactions with Firebird, and I read that setting NO AUTO UNDO with some transactions can speed up things. I am using Unidac in default mode with the default transaction, so I am not using any custom transaction code.

Is it possible to set this option, or does Unidac take care of this for me?

[ViktorV]

To set arbitrary transaction parameters, you should set the DefaultTransaction.IsolationLevel property to ilCustom, and set the parameters you need in the Params property. For example:

Code: Select all

UniConnection.DefaultTransaction.SpecificOptions.Values['Params'] := 'wait;read_committed;rec_version;no_auto_undo';

[kneighbour]

Thanks - a good suggestion.

If I set the Connection.DefaultTransaction.Isolationlevel for one particular UniQuery, surly that will change the isolation level for all the other UniQueries that are in the application?

ie UniQuery.connection.DefaultTransaction.IsolationLevel := whatever - surely that will effect all Uni controls using that connection?

[ViktorV]

Yes, you are right, the TUniConnection component and all datasets that work through it, use DefaultTransaction for all operation under data.
If you want to change the transaction settings only for a specific dataset, you can use a separate TUniTransaction component for this dataset.

[kneighbour]

Good idea. Many thanks for the useful comments.

[ViktorV]

Thank you for the interest in our products.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.