[Asterisk-Users] Asterisk and LCR

[Damon Estep]

> Hello,
> 
> How do you guys implement LCR in Asterisk?
> 

I have experimented with 2 ways, both seem to have issues and further
testing is taking place now.

Method1, use realtime for extensions and load your routing tables in an
outbound context. Our requirements are LCR for the ~150,000 USA NPA-NXX
combinations, everything outside of that goes through a single carrier
so no routing needed. The performance stinks, takes too long to start
the call. I need to do further testing and see if this is just a MySQL
server (hardware) performance issue or a database structure issue
(missing useful indexes).

The second method is to use #include lcrtableflatfile.conf in extensions
.conf and drop a single outbound context in that file with all of the
routes. This method is far faster completing calls, but the asterisk
reload command takes a long, long, long time (several minutes) to read
the huge file. During the reload calls fail.

Any input from others that have already done what I am doing would be
helpful, what works best?

Damon