thanks, i use the mtree module for about 5 million records.... does htable able to handle it as well?
On Fri, Feb 17, 2012 at 10:18 AM, Daniel-Constantin Mierla < mico...@gmail.com> wrote: > Hello, > > > On 2/16/12 2:51 PM, Javier Gallart wrote: > > Hello Uri > > I had similar needs and I found the ndb_redis module more suited for that > type of task. Instead of a tree you have a hash like this: tname tprefix > tvalue. If you do a hget nts $avp(DID) and you get a not null value you > have found your exact match. It works very well for me and the time it > takes for that "query" is barely noticeable. Of course redis does not > address items like persistence, etc the same way a rdbms does. > > > for hash tables in config, the alternative is using htable module. Then > the selection is done on exact match, no prefix matching. mtree is suitable > for storing keys that are composed from a limited set of characters (like > numbers, 0-9 digits only), otherwise becomes too memory consuming. For keys > that are composed from any character and need exact match, hash table > structures are more suitable, no matter if it is via htable module or > something else like redis. > > Cheers, > Daniel > > Hope it helps. > > Regards > > Javi > > On Thu, Feb 16, 2012 at 12:00 PM, > <sr-users-requ...@lists.sip-router.org>wrote: > >> Send sr-users mailing list submissions to >> sr-users@lists.sip-router.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >> or, via email, send a message with subject or body 'help' to >> sr-users-requ...@lists.sip-router.org >> >> You can reach the person managing the list at >> sr-users-ow...@lists.sip-router.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of sr-users digest..." >> >> >> Today's Topics: >> >> 1. how to match exact string value in mtree (Uri Shacked) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Thu, 16 Feb 2012 12:54:50 +0200 >> From: Uri Shacked <ushac...@gmail.com> >> Subject: [SR-Users] how to match exact string value in mtree >> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - >> Users Mailing List" <sr-users@lists.sip-router.org> >> Message-ID: >> <CAMMbDhTFNXAE-K88= >> aemjo7ana_qjv3ajj3ah-axemxn3ze...@mail.gmail.com> >> Content-Type: text/plain; charset="iso-8859-1" >> >> Hi, >> >> I am using Mtree to match prefix numbers, some of them starts with 0 or >> characters like D for example. >> so, the mtree param is like this: >> >> modparam("mtree", "db_url", CFGDB) >> modparam("mtree", "mtree", >> "name=nts;dbtable=service_numbers_view;type=0;") >> modpmodparam("mtree", "char_list", "0123456789*+#YMDabcdefgh") >> modparam("mtree", "pv_value", "$avp(mtval)") >> modparam("mtree", "pv_values", "$avp(mtvals)") >> >> The thing is, that i tried all: >> >> if(!mt_match("nts", "$avp(DID)","1")) >> if(!mt_match("nts", "$avp(DID)","2")) >> if(!mt_match("nts", "$avp(DID)","0")) >> >> and lets say i have the both prefix in the nts mtree: >> 09555 >> 09555333 >> >> And the prefix i search for is $avp(DID)=09555444 >> >> I allwasy get the 09555 because it is the longest match. >> I need exact match..... >> >> how do i do that? >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: < >> http://lists.sip-router.org/pipermail/sr-users/attachments/20120216/9d2eb778/attachment.html >> > >> >> ------------------------------ >> >> _______________________________________________ >> sr-users mailing list >> sr-users@lists.sip-router.org >> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >> >> >> End of sr-users Digest, Vol 81, Issue 40 >> **************************************** >> > > > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing > listsr-us...@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > > -- > Daniel-Constantin Mierla -- > http://www.asipto.comhttp://linkedin.com/in/miconda -- > http://twitter.com/miconda > >
_______________________________________________ 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
