[asterisk-users] Lookup ${EXTEN} in database, update context/route if found... AGI?

[Steve Edwards]

On Thu, 3 Jun 2010, Steve Edwards wrote:

>> -Also, what about slow queries? If a query takes a few seconds to 
>> complete, does the call wait for the query to complete or are there 
>> timeouts for the query that could result in dropped calls?
>
> (I prefer to call MySQL from an AGI instead of the dialplan. I find 
> "dialplan MySQL" ugly and limiting. I also don't like exposing a bunch 
> of code in an environment where someone can "fat-finger" a difficult to 
> find error.)

If you have a query (or an external process like a credit card 
authorization) that you just can't make faster, you can code your AGI to 
play a prompt ("Please wait while we...") in a separate thread while you 
do the query. The "customer experience" is that the query is 
instantaneous.

-- 
Thanks in advance,
-------------------------------------------------------------------------
Steve Edwards       sedwards at sedwards.com      Voice: +1-760-468-3867 PST
Newline                                              Fax: +1-760-731-3000