6 Jun
2011
6 Jun
'11
12:52 p.m.
2011/6/6 David Villasmil david.villasmil.work@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.
Thanks.
--
Iñaki Baz Castillo
ibc@aliax.net