Subject Re: Generator and Triggers with IB6 from Delphi and IBX
--- In ib-support@y..., "Robert F. Tulloch" <tultalk@a...> wrote:
> Hi:
> > I have a doubt it is solution. If two transactions got the same
> > max(Id)
> They can't. The table is locked while the sp executes thus causing
any other
> transaction/access to wait until lock is removed. The lock is
removed as soon as the
> sp returns.
Robert, do I right understand you lock the whole main table
(consistency isolation)? If that, this bottleneck is even narrower
than that I described. But if you don't need take care about according
ID sequence and insert sequence in time, both broads. :)