[Asterisk-Dev] RE: MYSQL application

[Domjan Attila]

On Tue, 2004-08-03 at 03:46, Kevin Walsh wrote:
> Constantine Filin [cfilin at intermedia.net] wrote:
> > > While I understand the concern of too many 'vendor' specific
> > > implementations, I applaud the inclusion of 'query', 'insert', etc.
> > > commands into the asterisk dialplan versus through an AGI.  If the
> > > general consensus is to move this into ast_data, then that is good as
> > > well, as long as the more useful database functions are not lost in the
> > > process. 
> > >
> > There is no problem if MYSQL is not included in CVS, still I thought if
> > this work well for me, then it might work for someone else as well.
> > 
> > On the subject of developing a single interface to all database from *
> > dialplans - what about unix ODBC and commands like
> > 	ODBC(Connect DSN connID ...)
> > 	ODBC(Query ${connID} resultID ...)
> > 	ODBC(Fetch ${resultID} fetchID...)
> > 	ODBC(Disconnect ${connID} ...)
> > 	ODBC(Clear${resultID}
> > would they be generic enough?
> > 
> ODBC is horribly inefficient.  I wouldn't go near it.  Perhaps a
> more generic interface would be better.  Something like the
> following:

Yes, I agree, and app_sql_mysql and others would be much faster if app_sql connect to database when modul loaded,
and keep the connection open.