[asterisk-users] AGI asterisk high balance
Lee Jenkins
lee at datatrakpos.com
Fri May 9 11:55:43 CDT 2008
Rizwan Hisham wrote:
> Well database really is a bottleneck for me. I am currently trying to do
> rating stuff in agi using perl. What im doing is i lookup the rate of
> every dialed code for every call from the mysql database using the
> longest match technique. The longest match technique costs atleast 2-3
> mysql queries for every call untill the dialed code is matched out of
> 14000 dialcodes. I dont know how to calculate the exact delay due to
> execution of agi, but on the asterisk cli whenever that agi executes,
> there is a visual delay of about half a sec to move from the agi
> extension to the next extension (can anybody tell me how to calculate
> the delay).
>
> Now im planning to use the manager api for constant connectivity to
> mysql and to enhance the longest match technique. Can anybody help me
> with this? Is it a good idea to ue manager api for lookingup the rate
> of the live call?
>
I'm a FirebirdSQL guy myself, but I find that if I implement connection pooling,
apps like the one you've described are faster since connection setup and tear
down are always expensive.
--
Warm Regards,
Lee
More information about the asterisk-users
mailing list