[asterisk-users] need examples of asterisk and mysql integration

[Al Baker]

I did not mean to stir up a hornet's nest or religious war :)
The BASIC QUESTION I was trying to ask is this...
   "Since the MYSQL add-on provides a way to interface with MySQL
     what is it that one gains or is trying to gain by writing their OWN
     AGI script to do the interface ?"

The only reason I mention this being a "performance hit" was that the 
book ATFOT
mentioned that AGI scripts in general were less efficient and therefore 
one should
do all possible work in the dial plan.

Maybe this is true, maybe this is not true.

Regardless.....

I would just like to borrow from the expertise and experience of other 
and ask the BASIC QUESTION above and hope that folks will share their 
experiences. I'm pretty sure they did what they did for very very good 
reasons that I am just not experienced enough yet to know.

So.... The answer to the questions is........ ???



Steve Edwards wrote:
>> On Wed, Apr 23, 2008 at 11:07:01AM -0700, Steve Edwards wrote:
>>     
>
>   
>>> AGIs do not have a substantial "performance hit" and I think people need
>>> to get this misconception out of their heads.
>>>
>>> Writing AGIs in a scripting, non-compiled language may be great for
>>> prototyping and proving concepts where performance is not expected to be
>>> an issue. Personally, I don't write AGIs in anything but C. It's the
>>> sharpest tool in my kit and I know it best.
>>>       
>
> On Wed, 23 Apr 2008, Tzafrir Cohen wrote:
>
>   
>> The dialplan isn't compiled either.
>>     
>
> I guess I didn't make that point forcefully enough.
>
>   
>> Now, if it is simple enough to be implemented with the dialplan, then 
>> you don't need to execute half the logic in a separate environment and 
>> don't need the performance hit.
>>     
>
> I'd like to put this "performance hit" thing to rest. I respect your 
> knowledge and expertise -- I always seem to learn something new (to me) 
> from your posts.
>
> How would you "quantify" the "hit?" On my recently retired dev box (1.6GHz 
> Celeron), I could execute 100 AGIs per second but that doesn't really 
> answer the question.
>
>   
>> Anyway, what about dialplan logic in lua? Anybody actually uses that 
>> thing?
>>     
>
> Oh great -- another scripting language to learn :)
>
> Thanks in advance,
> ------------------------------------------------------------------------
> Steve Edwards      sedwards at sedwards.com      Voice: +1-760-468-3867 PST
> Newline                                             Fax: +1-760-731-3000
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>