Hello Iñaki, I had much the same traffic, and with a good index that wouldn't be a problem, IMHO. You could also load the table in memory, can't be faster than that.
Of course, doing it in the config script is faster, but it limits your flexibility... just a thought... I even got the rate and created a "custom" cdr for each call. we had around 4k concurrent calls at that time (like 5 years ago) Anyway, good luck! David On Mon, Jun 6, 2011 at 2:52 PM, Iñaki Baz Castillo <[email protected]> wrote: > 2011/6/6 David Villasmil <[email protected]>: > > 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 > <[email protected]> > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list > [email protected] > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list [email protected] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
