Subject Re: [ib-support] Generator and Triggers with IB6 from Delphi and IBX
Author Robert F. Tulloch

> How many users have you got beating on that simultaneously? We've just
> been working with a company that had their system come to a grinding halt
> with just this kind of operation - everybody who stored a record had to
> update one particular record - performance degraded geometrically as the
> number of users went up.

I tested it with seven instances in a test where I commitretaining() manually to
watch the reactions of the other instances which were in loop waiting their turn. Each
one fired as a commitretaining was executed and they gained access.

Remember, the new record is added with the unique Id in an SP. The record is
commited as soon as the sp returns so the lock is very short.

Best regards