Hello IB-Support!

I need setting up isolation level for select statement, that shall
showing rows in DBGrid.

Which level is faster and not hard overhead in multi generation
architecture

1. Read commited
a) read only
b) read & write
2. Snapshot
a) read only
b) read & write

Refresh rows is programmed as follow:

{begin of code}
if Transaction.InTransaction then Transaction.Commit;
Transaction.StartTransaction;

ibquery.sql.text:='...select statement...';
ibquery.open;
{end of code}

But if is read commited faster, I can drop that part of code, which
start new transaction.



--
Best regards, TRoland
http://www.rotursoft.sk