Subject | How changes are written to disk |
---|---|
Author | kimon_the_athenian2 |
Post date | 2004-06-01T13:38:24Z |
Hi!
Can someone please explain briefly when/how Firebird writes changes
to disk, or is there something written about it somewhere in the web?
Until today, I assumed that my database file gets updated on every
commit and change in metadata, unless I alter something in
Firebird.conf (ForcedWrites?)
But then I noted that my database file was last modified yesterday
although I had worked on it several hours today (creating stored
procedures. I'm not sure if I made some data changes). Only when I
disconnected all clients from database, the file mod. date got
updated. Where were the updates stored until then, memory? some other
file?.
If there were power failure, would my work have been lost, or not?
What are the Firebird setup options dealing with this issue?
Is there difference in this question between server and embedded
version?
Thank you in advance!
Aivar
Can someone please explain briefly when/how Firebird writes changes
to disk, or is there something written about it somewhere in the web?
Until today, I assumed that my database file gets updated on every
commit and change in metadata, unless I alter something in
Firebird.conf (ForcedWrites?)
But then I noted that my database file was last modified yesterday
although I had worked on it several hours today (creating stored
procedures. I'm not sure if I made some data changes). Only when I
disconnected all clients from database, the file mod. date got
updated. Where were the updates stored until then, memory? some other
file?.
If there were power failure, would my work have been lost, or not?
What are the Firebird setup options dealing with this issue?
Is there difference in this question between server and embedded
version?
Thank you in advance!
Aivar