Re: Recover After Crash

From: Mike Kluev <kluev_at_stalker.-deIete-.gamma.ru>
Date: Fri, 15 Sep 2000 11:20:56 +0400
Message-ID: <B5E7B698.3CB9%kluev_at_stalker.-deIete-.gamma.ru>


In Article 8pq8c6$am7$14$1_at_news.t-online.com, Carl Rosenberger wrote:

>> So they will see modifications (potentially to other tables)
>> only after user will close document (transaction). This is
>> not appropriate. We need to modify other tables and other
>> people to see our modifications while document is open -
>> all this in *one* connection.

>
> Possibly Isolation Level 0 is O.K. for you.
> Typically you get a lot of ugly side effects though.

Thats why I am not into using it, I want to play safe.

> You could also use a locking mechanism outside of the database server, if
> you want to spare resources:
> Create a file on the server with an appropriate naming convention and open
> it for readwrite. The lock should be released instantly on any crash.

This method we currently use. I was hoping there is a way to solve this problem at database level only.

-- 
Mike Kluev.

PS. Remove "-delete-." part of my e-mail address to reply.
Received on Fri Sep 15 2000 - 09:20:56 CEST

Original text of this message