Re: Delete blocking other requests

[Paul DuBois]

At 1:39 PM -0700 9/6/01, Stuart Scamman wrote:
>Delete from table where var = ... blocks other sql requests such as
>select and insert on a multi-million record database until it is done.
>For example, to delete 11,000 records out of 13 million takes 2 min 30
>seconds.  All other connections are blocked until done.  Is there a way
>around this ?  Thanks ahead of time.

DELETE puts a write lock on the table, which blocks other readers and
writers.

-- 
Paul DuBois, paul@stripped