Re: [sqlite] blocking on insert

Thankyou, spot on the mark :) Now we've got it blazing fast, time to move backwards towards a reasonable mix of safety and speed. [EMAIL PROTECTED] wrote: > Bill KING <[EMAIL PROTECTED]> wrote: > >> Okay, i've got PRAGMA synchronous = OFF and PRAGMA temp_store = memory >> but i'm still seei

Re: [sqlite] blocking on insert

Which OS are you using to write to this SD-card database? And if Linux, which kernel and thread library are you using (LinuxThreads or NPTL)? --- Bill KING <[EMAIL PROTECTED]> wrote: > Okay, i've got PRAGMA synchronous = OFF and PRAGMA temp_store = memory > but i'm still seeing the system loc

Re: [sqlite] blocking on insert

Bill KING <[EMAIL PROTECTED]> wrote: > Okay, i've got PRAGMA synchronous = OFF and PRAGMA temp_store = memory > but i'm still seeing the system locking up and waiting for write when > writing to sd-cards PRAGMA synchronous=OFF prevents SQLite from calling fsync() and fdatasync(). On most fil

[sqlite] blocking on insert

Okay, i've got PRAGMA synchronous = OFF and PRAGMA temp_store = memory but i'm still seeing the system locking up and waiting for write when writing to sd-cards (insert statement in the middle of a batched transaction of them) (for reference, the standard linux filesystem doesn't have this bloc