Re: [sqlite] how it works

2007-03-22 Thread Jakub Ladman
Dne čtvrtek 22 březen 2007 13:16 [EMAIL PROTECTED] napsal(a): > 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

Re: [sqlite] how it works

2007-03-22 Thread drh
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 databas

Re: [sqlite] how it works

2007-03-22 Thread A.J.Millan
> 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 > g

[sqlite] how it works

2007-03-22 Thread Jakub Ladman
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 b