Preferred method for mysql database interaction

I would like to have Asterisk interact with a mysql database on my LAN via the dialplan. What is the most efficient way of doing this. Currently I am going the Perl/AGI route. What about ODBC? Is ODBC much slower and what are the pros/cons? I happen to be using Asterisk 1.8, does that mean I can just use the “app_mysql” to interact with a database now and not have to resort to an AGI script?

Thanks. Joel

The ODBC connector is the preferred method for connecting to DBs.

Why is that? Doesn’t performance take a hit when there is the added ODBC layer?

It’s additional overhead, yes, but the overhead from moving around VoIP calls is generally the thing that’s going to eat the most resources on a system.

The ODBC connector is the one that’s preferred because it’s the easiest one for us to support - they’re doing all of the abstraction to other DBs for us, so we don’t have to worry about the intricacies.

Ahh. Ok thanks for the response.