Holger Hans Peter Freyther
holger at freyther.de
Wed Aug 11 17:49:49 UTC 2010
On 08/12/2010 12:33 AM, Konrad Meier wrote:
> Yes, if think it is triggered by the size of the database. My hlr.sqlite is
> about 20MB big an is growing every day about 2MB. If I take a look at the
> Tables, I can see that the only big table is "Counters".
> Is there any reason why the table "Counters" is growing this fast?
In src/bsc_hack.c we are scheduling to sync the "Counters" every 60 seconds
you might want to increase the define as a hacky workaround.
>> -) Figure out why we are stalling (rw locks inside sqlite?)
>> -) Create an index for the sqlite databases... (proof it is making
>> things faster with a standalone benchmark having the same pattern
>> as bsc_hack in your network...)
>> -) Making the DB interface asynchronous (send and forget, send and
>> async reply)
>> -) Maybe go so far to use TCAP/MAP and implement a proper VLR module..
> I will see what I can do.
It would be very nice to have a histogram of which functions block, is it
everything, just one query or really the write?
More information about the OpenBSC