[Asterisk-Users] Nested MySQL Commands

Douglas Garstang dgarstang at oneeighty.com
Wed Jan 11 11:39:20 MST 2006


Peter,

Too slow! We're going to potentially be doing several MySQL lookups for routing even the most basic of calls, and if every one of those queries has to make a call out to an AGI script, it would become a performance problem.

Douglas.

-----Original Message-----
From: Peter Bowyer [mailto:peeebeee at gmail.com]
Sent: Wednesday, January 11, 2006 11:27 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Nested MySQL Commands


On 11/01/06, Douglas Garstang <dgarstang at oneeighty.com> wrote:
> Is it possible to have nested MySQL queries in extensions.conf?
>
> Ie, perform a query, grab a value, and then jump to another location in the
> dialplan and do another query based on that original value. I'm having
> problems with the result and fetchid's and I'm not sure if it's even
> possible to do this or not.

When things start to get that complicated, I reckon it's time for AGI....

Peter

--
Peter Bowyer
Email: peter at bowyer.org
Tel: +44 1296 768003
VoIP: sip:peter at bowyer.org
VoIP: *5048707000 at sipbroker.com
FWD: **275*5048707000
VoipTalk: **473*5048707000
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users



More information about the asterisk-users mailing list