| Subject | Re: Odp: [firebird-support] Re: Insert ot update sta tements locks a table and all other instances th at try to run same statement are lcoked to |
|---|---|
| Author | |
| Post date | 2014-09-07T12:22:07Z |
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.
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.