Hi,

<<Depending on the business logic it can be much more shorter (some millisecounds) than locking in „parent” transaction

Yes, good point.

We need data as fast as possible but valid data (its without user interactions).

I will look if some eficient solution we can create with your and others hints.

But i am worry that we must stay with current implementation as it is slow but safe.

I am curious, if connection to database is droped (hard way) is ON TRANSACTION ROLLBACK trigger fired?

Regards,

Karol Bieniaszewski