SmartQuery performance in grid editing
Posted: Tue 06 Jan 2009 19:55
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.
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.