[SR-Users] Using =~ to get the group identifier with longest match

[Daniel-Constantine Mierla]

On Jun 6, 2011, at 2:52 PM, Iñaki Baz Castillo <ibc at aliax.net> wrote:

> 2011/6/6 David Villasmil <david.villasmil.work at gmail.com>:
>> I connected to mysql and ran something like:
>> select * from routes where '$rU' like concat(areacode,'%') order by
>> len(areacode) desc limit 1;
> 
> Hi David, that would work indeed, but I prefer not to saturate the DB
> with such a query which cannot use table indexes. My kamailio handles
> 2000-3000 concurrent calls and such calls come from callcenters so
> they are very "aggressive" (maybe 200-300 calls in the same second),
> so querying the database with a low performance query is not an option
> in my case.

Btw, very lightweight module for longest prefix matching is mtree. It has option to return a value in a cfg variable, that can be the group id for example. It does caching in memory trees, so it is really fast in matching.

Cheers,
Daniel

> 
> Thanks.
> 
> -- 
> Iñaki Baz Castillo
> <ibc at aliax.net>
> 
> _______________________________________________
> 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