Re: [sqlite] doing everything sqlite warns against

2006-12-09 Thread drh
"Hickey, Larry" <[EMAIL PROTECTED]> wrote: > I have a system requirement that feeds thousands of keyed records, each of > which contains a blob of around a meg or so into an sqlite database. Ok so > far. But the records come from multiple > processes, and I can't afford to do have commits after eac

[sqlite] doing everything sqlite warns against

2006-12-08 Thread Hickey, Larry
I have a system requirement that feeds thousands of keyed records, each of which contains a blob of around a meg or so into an sqlite database. Ok so far. But the records come from multiple processes, and I can't afford to do have commits after each insertion for obvious performance reasons (if you