<HTML dir=ltr><HEAD><TITLE>Re: [asterisk-dev] "Asterisk cmd MYSQL" app_addon_sql_mysql /performance ?</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6001.18148" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText92734 dir=ltr>
<DIV dir=ltr><FONT face=Verdana color=#000000 size=2>I was not sure about anything, your answer is very helpfull, much appreciated</FONT></DIV>
<DIV dir=ltr> </DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> asterisk-dev-bounces@lists.digium.com on behalf of Tilghman Lesher<BR><B>Sent:</B> Tue 05/05/2009 3:53 PM<BR><B>To:</B> Asterisk Developers Mailing List<BR><B>Subject:</B> Re: [asterisk-dev] "Asterisk cmd MYSQL" app_addon_sql_mysql /performance ?<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>On Tuesday 05 May 2009 08:58:28 Julien Chavanton wrote:<BR>> I was looking for a (http socket module / mysql module) not using<BR>> AGI(perl/php/shell) for asterisk in order to do intensive database / web<BR>> server interactions as needed without performance to much overhead.<BR>><BR>> Is there a real benefit in using : "Asterisk cmd MYSQL" app_addon_sql_mysql<BR>> , I see it require perl DBD so it is not using Mysql C API, then there must<BR>> be an instance of the perl interpreter for every query ?<BR><BR>You are quite mistaken. The MYSQL app addon uses native MySQL calls, not<BR>Perl. However, we recommend that you use func_odbc, both because it supports<BR>multiple databases as well as because its usage won't cause resource leaks<BR>(the usage of the MYSQL app addon may cause resource leaks, if you aren't<BR>careful). If you want an HTTP socket module, please see func_curl.<BR><BR>--<BR>Tilghman<BR><BR>_______________________________________________<BR>--Bandwidth and Colocation Provided by <A href="http://www.api-digital.com--/">http://www.api-digital.com--</A><BR><BR>asterisk-dev mailing list<BR>To UNSUBSCRIBE or update options visit:<BR> <A href="http://lists.digium.com/mailman/listinfo/asterisk-dev">http://lists.digium.com/mailman/listinfo/asterisk-dev</A><BR></FONT></P></DIV></BODY></HTML>