--- 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. :)