In this particular case the heavy load is not in this table. It is another 
table. 

This insert is run only once a day when the first client connects to the system.

All other clients should be able to see the inserted records and will just load 
them.

The problem might happen only of 2 clients try to login at the same time and 
they both see that todays records are not here and try top insert them in 
different transactions. 

But in that case I expect one of the transactions to fail and to produce error. 
Not to block the execution of other insert statements.

There is no triggers or references to other tables that are inserted in the 
same transaction.
  • ... 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
    • ... doyc...@dsoft-bg.com [firebird-support]

Reply via email to