[Asterisk-Users] Asterisk and LCR

[Innocent Evil]

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: asterisk at lists.styx.org
> Sent: Tue, 16 Aug 2005 12:57:14 -0400
> To: asterisk-users at 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 -NO at SPAM- magicphone.ca
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at 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