[asterisk-users] IVR and MySQL

[Atis]

On 8/16/07, Andreas Sikkema <andreas.sikkema at bbeyond.nl> wrote:
> Using MYSQL() (or equivalent) heavily in the dialingplan is IMHO the
> nicest way of doing things like this. You can do lots of simultaneous
> calls before getting into trouble.

Well, it is simple, but creates a LOT of load. Plus, if you might run
in troubles, if you forget to do disconnect at some point (or lot of
calls get's hanged up without disconnecting from MySQL).

>
> Appending stuff to the CDR userfield is just plain ugly and asking for
> trouble (are you sure you can always separate the different values?).

Well, for me it is working excellently. Plus you get all the info
already binded to call. I use # as separator - i don't have values
that may contain it (and it's quite distinguishable when browsing DB)

Regards,
Atis


-- 
Atis Lezdins,
IT Responsible of BEST Riga,
atis at BEST.eu.org
ICQ: 142239285
Skype: atis.lezdins
Cell Phone: +371 28806004 [Tele2, Latvia]
Work phone: +1 800 7502835 [Toll free, USA]
?BEST? -> www.BEST.eu.org