Subject | Re: [firebird-support] detect if database has changed |
---|---|
Author | Alexey Kovyazin |
Post date | 2017-10-09T06:11:19Z |
Look at System Audit feature.
Regards,
Alexey Kovyazin
IBSurgeon HQbird
www.ib-aid.com
On 09.10.2017 2:49, Hamish Moffatt hamish@... [firebird-support] wrote:
Is there an official way to detect if a database has changed?
I have some expensive reports and backups to run, but if I know that the
database has not changed since I last ran them I can skip those.
fbstat (gstat) shows the next transaction number, but that changes even
when only read-only transactions have run.
Currently I am looking at the timestamp of the .fdb file, which also
changes when only read-only transactions run.
I would like to know if the data or schema actually changed, not just a
transaction has run that didn't change anything.
Thanks
Hamish