Re: [sqlite] Insert optimization

How to improve the write speed then. I've found that in most cases using "chained" insertion speeds up things dramatically: insert into mytable (x, y, z) values (1, 2, 3), (4, 5, 6), (7, 8, 9), ... If you insert K rows at a time this way your total insert time can by cut by a significant

Re: [sqlite] Insert optimization

On 22 Aug 2014, at 7:08pm, Sherry Ummen wrote: > We have been trying out couchbase lite which uses sqlite underneath. > > I want to know how safe is use > PRAGMA synchronous = OFF"); > "PRAGMA journal_mode = MEMORY" > > I have been suggested not to use it but then its

[sqlite] Insert optimization

Hello, We have been trying out couchbase lite which uses sqlite underneath. I want to know how safe is use PRAGMA synchronous = OFF"); "PRAGMA journal_mode = MEMORY" I have been suggested not to use it but then its soo dangerous then why is it thr in first place? It says the databse might