On Wed, Dec 5, 2012 at 11:10 AM, Keith Chew <keith.c...@gmail.com> wrote: > The strange thing is that I am setting sqlite it to use WAL, > autocheckpoint off and synchronous off. Even in this setup, I still > see > 350ms transactions times for less than 3 TPS. A bit hard to > believe, so I am now doing a strace to find out exactly what is > hitting the disk.
II can confirm using strace that there are no fsyncs happening from the application (which we expect because synchronous=0). So, it must be something else that is causing these blocks. Somekind of file locking issue (particular to my environment)? What else should I be looking at? Regards Keith _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users