> How about this: > > 1. Put all the routes of all the providers in a MySQL table > 2. Write a script with a 'clever' algorithm to find out cheapest route of > each prefix.
Are you saying realtime mysql is not clever? That is exactly what it is supposed to do. > 3. Based on #2.. make a lcr_cheapest_route.conf > 4. include lcr_cheapest_route.conf in extension.conf That is what we are doing, 3 minute reloads! > > But I don't know, how much resource asterisk will take after loading > lcr_cheapest_route.conf > Also, I don't have any idea about the performance would be. > > What do you think? > > Thanks > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > Sent: Tue, 16 Aug 2005 12:57:14 -0400 > > To: asterisk-users@lists.digium.com > > Subject: Re: [Asterisk-Users] Asterisk and LCR > > > > On Tue, Aug 16, 2005 at 10:22:01AM -0600, Damon Estep wrote: > > > > > > Any input from others that have already done what I am doing would be > > > helpful, what works best? > > > > For 100k routes+, you will have trouble holding them in a SQL database, > > particularly if your route selection query is complex. With a modern PC > > running PostgreSQL, you'll run into trouble at around 250k BHCA even > with > > a much smaller number of routes. (This is quite apart from Asterisk > > itself, > > try writing a simple program that runs sample queries in a loop, perhaps > > with several threads. To a certain extent it depends on how you write > the > > query and how judiciously you place indexes on the tables) When you want > > NPANXX granularity from several carriers (commonly 75-100k routes each) > > you'll get hit even worse. > > > > In my experience the safe limits of this approach are about a 2x DS3 > > worth of traffic with 10,000 routes in the table... After that you've > got > > to pull everything into RAM and write a clever route selection > > algorithm... > > > > -w > > -- > > William Waites > > ww [EMAIL PROTECTED] magicphone.ca > > _______________________________________________ > > Asterisk-Users mailing list > > Asterisk-Users@lists.digium.com > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk- > users_______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users