Subject | Re: [firebird-support] When is database file actually saved |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-07-14T11:54:07Z |
Hi Alexander,
column (not even if you refresh), but _does_ show it in the Properties
box. My my, how about that for consistency ;-)
But a limitation of this method is that changes - even inserts - don't
always lead to an increase in file size.
BTW, I just came across some more Windows Weirdness whilst playing
with this on a notebook with WinXP Home:
I opened a db, made and committed changes, kept the db open, and then
made a filesystem copy from the Explorer. To my surprise, the copy had
the same (old) timestamp as the original in the Explorer.
I thought maybe Forced Writes was off (although I never turn that off)
so I opened the copy and... yes sir! The copy contained the fresh
changes I made in the original, although it still had the original's
pre-modification timestamp!
IIRC Win2K gives the copy the correct - current - timestamp. (Don't
have my Win2K partition active right now.)
Greetings,
Paul Vinkenoog
> Here's similar but different way to verify changes were written toThat's nice! So Windows doesn't show the changed size in the Explorer
> database:
>
> 1. Open the database with any tool, make some changes and commit
> them. Keep the db open.
>
> 2. In the Windows Explorer, right-click on the database file and
> choose Properties.
>
> 3. Verify file size.
column (not even if you refresh), but _does_ show it in the Properties
box. My my, how about that for consistency ;-)
But a limitation of this method is that changes - even inserts - don't
always lead to an increase in file size.
BTW, I just came across some more Windows Weirdness whilst playing
with this on a notebook with WinXP Home:
I opened a db, made and committed changes, kept the db open, and then
made a filesystem copy from the Explorer. To my surprise, the copy had
the same (old) timestamp as the original in the Explorer.
I thought maybe Forced Writes was off (although I never turn that off)
so I opened the copy and... yes sir! The copy contained the fresh
changes I made in the original, although it still had the original's
pre-modification timestamp!
IIRC Win2K gives the copy the correct - current - timestamp. (Don't
have my Win2K partition active right now.)
Greetings,
Paul Vinkenoog