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. 3. Based on #2.. make a lcr_cheapest_route.conf 4. include lcr_cheapest_route.conf in extension.conf
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
