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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users