>
>Hi Dmitry
>
>Like Mike, we set a flag on the row when the user "deletes" a record. We have a kind of OLTP system with many inserts and deletes during the day. We found that if we deleted the records when the user deleted, we were seeing a lot of blocking (and deadlocks). We defer the actual removal of records from tables to a batch job that runs nightly. Performance improved considerably.
>
>Bruce
Bruce,
Thank you for your input.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham