[SR-Users] Load database table in memory

[Gary Chen]

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 at evaristesys.com>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<http://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html>
>
> -- 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 at lists.sip-router.org
>> http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**users<http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
>>
>>
>
> --
> 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 at lists.sip-router.org
> http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**users<http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130703/ac20b79e/attachment-0001.html>