Subject | Re: [firebird-support] Implementing dirty flag in a Firebird database |
---|---|
Author | Lester Caine |
Post date | 2005-05-17T15:42:10Z |
nocsav wrote:
Create a table with current and backup timestamp field, update the
current field every time there is an insert or update ( via the triggers
) and check it against the last backup date before doing a backup - at
which time you update both just before the backup.
A bit cumbersome but it works ;)
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
> I'm working on a Firebird application where the user can perform aAdd a few triggers?
> backup (gbak) through our user interface. We'd like to save time by
> skipping the backup if the user hasn't made any changes to the
> database since the last backup.
>
> We're looking into ways of doing this in the application code, but I'm
> wondering if Firebird has anything built in to help us.
Create a table with current and backup timestamp field, update the
current field every time there is an insert or update ( via the triggers
) and check it against the last backup date before doing a backup - at
which time you update both just before the backup.
A bit cumbersome but it works ;)
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services