You can try to help your issue by running "PRAGMA synchronous = OFF;" after you open your connection.
Cheers, Shawn Wilsher Mozilla Developer On Thu, Jul 10, 2008 at 3:04 PM, X Wang <[EMAIL PROTECTED]> wrote: > Hi, I have a sqlite in-memory databse that I want to periodically dump to a > disk file (so I can look into its contents at runtime). Currently I "ATTACH" > an extern file. Periodically I export everything from in-memory databse into > the attached extern file and do a final COMMIT. However, this sometimes takes > a long time (20 seconds) and totally freeze my multithreaded process(why > would this freeze my network I/O threads? Maybe because those threads also do > some logging?)... > > This is on Linux ext3, I also read a bit about Firefox's issue, so I think > this is due to "fsck". For my issue, actually I do not care too much about > data integrity. Is there a way to reduce sqlite's fsck to minimum? > > Thx > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
