Preferred method for mysql database interaction.

[joelshas]

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

[malcolmd]

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

[joelshas]

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

[malcolmd]

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.

[joelshas]

Ahh. Ok thanks for the response.