Re: Blocking Question

"JD" <jd_at_hotmail.com> wrote in message
news:wo7Ne.9803$p%3.38331_at_typhoon.sonic.net...
> We have a puzzling situation where doing a series of Inserts will block.
> The
> user has a transaction consisting of 4 inserts then has to confirm and we
> commit. If a second user starts the same sequence, the 4th insert will
> block
> until the first user commits. Our database people felt that there was a
> problem with foreign keys and indexes. Googling turns up lots of info on
> this.
>
> So, after an unsuccessful series of tests designed to locate the offending
> key, they disabled all of the foreign keys. Still blocked. So here's the
> question -- What other things will cause an insert to block? These are all
> new rows being inserted and each user has a different set of rows. And
> there
> are some triggers on a row insert.
>
> TIA,
>
> Mike P
>

Just for completeness --- The database guys were focused on foreign keys and indexes. But the locking culprit turned out to be a bitmapped index.

Mike P Received on Wed Aug 31 2005 - 14:28:37 CDT