> 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? > Do you understand me? > I do not know how to conceive this question in English exactly. > > Best regards > > Jakub Ladman >
Besides what can say on the matter the forum's gurus, included the own author Mr. Hipp, it is a matter of fact that the process to write in external devices is regularly monitorized by the OS. Sometimes the compiler uses its own buffer system that run over the Systems buffers. Although there are some resources to force a real write in some circumstances, with some languages and some compilers. flush, commit, etc. (_commit in MS VC++). A.J. Millan ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
