Re: Blocking Question

On Wed, 31 Aug 2005 19:28:37 GMT, "JD"
<MrJackDanielsBlack_at_Hotmail.com> wrote:

>
>"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
>

Mike,

Thanks for being so considerate as to provide this follow-up.

Jaap. Received on Thu Sep 01 2005 - 12:07:13 CDT