|Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread|
|Messages 1 to 3 of 3 total|
|Wed, Sep 12 2007 7:18 AM||Permanent Link|
During a backup, is there any way to get a normal query to work?
It seems that a backup causes a read lock on the tables.
I'm pondering how to get this to work sensibly - possibly keeping a note
of when the last transaction was and waiting for 10 mins. The backup
should be done in the middle of the night when no one is around, but I'm
also coding it to make a backup 5 mins after opening if it hasn't done one
recently, and of course that's an awkward time if the backup takes a
minute or two.
Any thoughts on this issue welcome!
|Wed, Sep 12 2007 1:11 PM||Permanent Link|
Tim Young [Elevate Software]
Elevate Software, Inc.
<< During a backup, is there any way to get a normal query to work? It
seems that a backup causes a read lock on the tables. >>
Sure, you should be able to read the tables just fine during a backup. The
only restriction is that a backup prevents any writes to the tables.
|Thu, Sep 13 2007 5:04 AM||Permanent Link|
Thanks - I'll work out where I'm failing then. Hmm, instant thought is
that I think I write a "last seen" time. I'll stop that if backup is
active and see if that fixes it. Many thanks for the confirmation that it