On Wed, 11 Jan 2006 11:39:20 -0700
"Douglas Garstang" <[EMAIL PROTECTED]> wrote:
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:[EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
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
Has anyone yet played with MySQL version 5?? My
understanding is that is now includes stored procedures.
Wonder if that will help things with Asterisk? Send a
query over to the MySql server with only the required
parameters and have it do all the processing for you and
only returns the results.
I know that is a nice feature od Microsoft Sql. But have
not had a chance to read up on the performance of the new
version of MySql...
Robert
_______________________________________________
--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