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 <abalas...@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@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@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> >
_______________________________________________ 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
