Am 12.08.2010 17:34, schrieb Konrad Meier:
This is a "feature" of SQLite. After each INSERT, that is not part of an transaction, the database is writen to disk using fsync(). This leads to a huge performance penalty. Disabling this behaviour using PRAGMA synchronous = OFF at startup is IHMO fairly easy way to solve this problem.Today I did some time measurements in the db.c (Debug log attached).I think the problem is that that the insert-query of the counter values are blocking the program.
Greetings Felix [1] http://www.sqlite.org/faq.html#q19 -- Felix Rublack - [email protected] - ICQ 242148137 - PGP/SMIME welcome! Tätig ist man immer mit einen gewissen Lärm. Wirken geht in der Stille vor sich. -- Peter Bamm
smime.p7s
Description: S/MIME Cryptographic Signature
