> I have an application written using sqlite. It writes into the > database very intensively. And I noticed that it works nice and very > fast but from time to time it just freezes for several seconds (I've > registered freezes up to 8 secs). After some tracing of sqlite code
I had the same problem. Also, it was increasing with database size. Depending on your environment, work procedure and whether you want speed or security, there are two things that work beautifully for me: 1) do the intentsive work on a db copy that sits on a ramdisk (or tmpfs filesystem). I do that if I have to create a new database or rebuild this from scratch, and since the process is supervised, there is not really a danger of data loss. 2) for normal operation, I use a software RAID from flash disks, which is not as fast (for data transfer) as a hard drive or SSD, but it is has a response time better by an order of magnitude (at least) than even a good hard drive. j. -- ---------Dr. January Weiner 3 -----------------+------------------- Inst. of Bioinformatics, UKM, Univ. of Muenster | Von-Esmarch-str. 54 (+49) (251) 83 53002 | D48149 Münster http://www.compgen.uni-muenster.de/ | Germany _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
