SmartQuery performance in grid editing

[jdorlon]

Hello,

I am using the latest version of ODAC with Delphi 2009.

When I attach a smartquery to a grid and try to edit data, I'm seeing slow performance because this query is firing over and over:

begin
:result := sys.dbms_transaction.local_transaction_id;
end;

It is coming from TOCITransaction.LocalTransactionId.

I understand that this pl/sql block is used to determine if a transaction is in progress, but why does ODAC have to execute it? Is there an option I can use to disable this feature?

Thank you.

[Plash]

You can set the LockMode property of TSmartQuery to lmNone to disable this feature.