4 Jul
2013
4 Jul
'13
9:34 a.m.
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/