В сообщении от Thursday 10 July 2008 23:04:28 X Wang написал(а): > 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?
You can create triggers for in-memory database for realtime sync this with attached file database. It's may be usefull for faster read operations. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
