Hi,

I'm testing delphi OmniThreadLibrary with Firebird 2.5.1 and FibPlus 7.0.

I'm doing a writing test, trying to find the best way to do multithreading
writing tasks, for example:

With two different threads, with two different connections and transactions
doing an update to the same record:

for i = 0 to 1000 do begin
....
UPDATE TABLE1 SET FIELD1= FIELD1+1 WHERE ID = 1
transaction.commitretaining;
end

As i expected, i get a lot of deadlocks, even with isc_tpb_read_committed
and isc_tpb_wait in the transactions.

Is there any transaction isolation mode that could achieve this, like
in-memory multithreading with critical sections for global variables? Or
any way to do a lot of multithreading writes trying to avoid deadlocks?

For now, the only way that works correctly is with an autonomous
transaction inside a procedure, but i would like not to put autonomous
transactions in all my

Thank you very much.


[Non-text portions of this message have been removed]