Patch to add index to SMS table

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/.

Holger Hans Peter Freyther holger at freyther.de
Wed Mar 25 23:41:24 UTC 2015


On Wed, Mar 25, 2015 at 02:46:23PM +0300, Alexander Nikolaev wrote:
> Hi,

Hey,

> Patch: https://gist.github.com/ati/5ef481954f5bd38d00fc

great! What is the benefit of using ";" to execute both
statements with a single sqlite3 command in db_prepare?
Any disadvantage to introduce a new key for the index?


> SQL queries benchmark script (python):
> https://gist.github.com/ati/bd03be698a89e24d8a89

What we would like to do is to avoid using libdbi. It has
known and unfixed memory access issues, for sqlite3 it
needs to execute pragma statements for each column we
query. Would you be interested to do more work on the
database interface?

holger




More information about the OpenBSC mailing list