On 1/30/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Shane Harrelson" <[EMAIL PROTECTED]> wrote:
> what's the most reliable method for checking the size of the jounal
> file for a database? is there anyway to flush that or sync it during
> testing? i tried using stat() on the jounral file but under windows
> it sometimes reports the jounral file having size 0 even though I know
> it's not empty.
>
The journal file for a database should not exist except when
a transaction is active or after a transaction failed due to
program crash or power failure.
What is it, exactly, that you are trying to do?
--
D. Richard Hipp <[EMAIL PROTECTED]>
Before I commit a transaction, I'm trying to measure the size of the
journal file to determine typical resource usage for my application.
The journal file for 1000 inserts on an empty database is much smaller
(as far as I can tell) then the journal file for 1000 inserts on a
database with 100k records (which is to be expected, AFAIK).
However, trying to "stat" the journal file under Windows before the
commit seems to produce unpredictable results (probably because of
flushing/syncing delays).
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
