Avoid LCR-Stalling

This is merely a historical archive of years 2008-2021, before the migration to mailman3.

A maintained and still updated list archive can be found at https://lists.osmocom.org/hyperkitty/list/OpenBSC@lists.osmocom.org/.

Felix Rublack frubi at frubi.net
Thu Aug 12 17:56:12 UTC 2010


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 at 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4681 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.osmocom.org/pipermail/openbsc/attachments/20100812/77efb222/attachment.bin>


More information about the OpenBSC mailing list