[Asterisk-Users] Nested MySQL Commands

[Robert Webb]

On Wed, 11 Jan 2006 11:39:20 -0700
  "Douglas Garstang" <dgarstang at oneeighty.com> 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: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


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