Patch to add index to SMS table

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

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


> Patch:

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):

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?


More information about the OpenBSC mailing list