Jakub Ladman <[EMAIL PROTECTED]> wrote: > Hi > > I need to know how this works in detail: > I have sqlite3 database file stored on SD/MMC FLASH card and i would to > insert > rows to some tables often. There will be triggers to clean old and obsolete > data. > How often it will write to database file? After every INSERT command, or it > goes to some buffer in ram and file is updated as late as multiple inserts > are done?
The database file is written when you COMMIT (either implicitly or explicitly) or when the internal cache overflows. The rollback journal file on the same flash card is written continuously as you make changes. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
