"Shane Harrelson" <[EMAIL PROTECTED]> wrote: > > 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). >
There is no mechanism in SQLite for measuring the size of a journal file. If "stat" is not working for you on windows, I'm afraid there isn't much I can do to help. SQLite itself uses GetFileSize() to determine file sizes on win32 and that seems to work reasonably well. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
