[SR-Users] Load database table in memory

[Alex Balashov]

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

-- 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
>


-- 
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/