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
