12 Aug
2010
12 Aug
'10
7:56 p.m.
Am 12.08.2010 17:34, schrieb Konrad Meier:
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.
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.
Greetings
Felix
[1] http://www.sqlite.org/faq.html#q19
--
Felix Rublack - frubi(a)frubi.net - ICQ 242148137 - PGP/SMIME welcome!
Tätig ist man immer mit einen gewissen Lärm. Wirken geht in der Stille
vor sich. -- Peter Bamm