[asterisk-users] AGI asterisk high balance

[Lee Jenkins]

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