Keith Chew wrote: > In the application, it opens 5 connections and put them in a pool.
Please note that SQLite has no write concurrency (actual writing to the DB file requires an exclusive lock), and that there is also no synchronization between multiple connections -- when one connection does not get the exclusive lock, it just waits a little time before trying again. It's possible that it's these waits that you're seeing. > I had a look, and at the most 3 connections are used at a time. Try it with one connection at a time. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
