Re: Avoid LCR-Stalling

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