4 Jul
2013
4 Jul
'13
4:09 a.m.
I am using mtree for the same purpose and it works great. It never expire.
I had loaded about 7 millions records in mtree table and there is no
performance issue at all.
Gary
On Wed, Jul 3, 2013 at 7:57 AM, Alex Balashov <abalashov(a)evaristesys.com>wrote;wrote:
Sure, you can do it that way. However, htable and
mtree accommodate
relatively primitive data sets.
Given sufficient table complexity and/or size, your best bet is to use an
in-memory storage backend on the database side itself.
In MySQL, this is called:
http://dev.mysql.com/doc/**refman/5.7/en/memory-storage-**engine.html<ht…
-- Alex
On 07/03/2013 05:41 AM, Grant Bagdasarian wrote:
Hello,
I need to query a database for every SIP request coming into Kamailio,
but I want this to be handled as fast as possible, so I was thinking of
loading the data I need in memory using the HTABLE or MTREE modules.
When the SIP request is coming from one of our carriers, the called
number ($rU) must be used to get the data for this called number.
Normally, I would query the database, using sqlops, and pass the value
of $rU as the parameter and get the column values using the $dbr
variable. Can this be accomplished with HTABLE or MTREE?
Also, the autoexpire parameter in HTABLE; once expired, will the data be
reloaded again from the database?
Thanks,
Grant
______________________________**_________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**users<http:/…
--
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/
______________________________**_________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**users<http:/…