[SR-Users] Load database table in memory

[Alex Balashov]

On 07/04/2013 03:10 AM, Grant Bagdasarian wrote:
> Alex, we’re primarily using MSSQL as our database server and would like
> to keep it that way. But since Gary has accomplished this with MTREE,
> I’ll give that a go. 7 million records is very impressive. Our tables
> won’t have near that much records, just a few hundred.
>
> I’d like to reload the data every x interval, but I don’t see the MTREE
> having support for this, except a MI command mt_reload. I can’t call
> this from within the configuration script right? If not, how does the
> TIMER module work? Does it run independently from requests, and gets
> triggered every set interval?

I think what you want is rtimer:

    http://kamailio.org/docs/modules/4.0.x/modules/rtimer.html

And indeed, you can think of it as a kind of cron daemon that runs 
outside the SIP message processor thread pool.

While there is no way to trigger an mtree reload from inside route 
script, you can use rtimer + the 'exec' module to trigger one from the 
outside, using the 'mt_reload' MI command that you mentioned above:

    http://kamailio.org/docs/modules/4.0.x/modules/exec.html

-- Alex

-- 
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/