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
Douglas Garstang ha scritto:
Peter, I assume you mean something like this in extensions.conf:
exten = _X.,1,AGI(master-dial-logic.pl)
and then there's only one call. All logic would be performed by the perl
script. This has many advantages. One disadvantage however is that potentially,
Douglas Garstang ha scritto:
So I really wish there was some way to measure how well the worst case scenario
would perform. This would be 120 simultaneous calls (don't know how many per
second) on a Dual 3.8Ghz Dell PowerEdge 1850 with 2GB RAM. Asterisk would call
an AGI script, written in
AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: RE: [Asterisk-Users] Nested MySQL Commands
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
Simone Cittadini wrote:
Douglas Garstang ha scritto:
So I really wish there was some way to measure how well the worst
case scenario would perform. This would be 120 simultaneous calls
(don't know how many per second) on a Dual 3.8Ghz Dell PowerEdge 1850
with 2GB RAM. Asterisk would call an
Andreas Sikkema 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
On 1/13/06, Mike Fedyk [EMAIL PROTECTED] wrote:
[..snip..]
Also an ugly hack would be to call the perl bytecode instead of the text
script. That would allow for the ease of AGI (everything is cleaned up
when the process exits) with lower overhead.
FastAGI is of course what you want for
Message-
From: Mike Fedyk [mailto:[EMAIL PROTECTED]
Sent: Thu 1/12/2006 9:33 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Cc:
Subject: Re: [Asterisk-Users] Nested MySQL Commands
Simone Cittadini wrote
-Users] Nested MySQL Commands
On 1/13/06, Mike Fedyk [EMAIL PROTECTED] wrote:
[..snip..]
Also an ugly hack would be to call the perl bytecode instead of the
text
script. That would allow for the ease of AGI (everything is cleaned
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
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
:[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
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
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.
THe above describes the whole point of a SQL DBMS Server.
WHat else could you ask one to do for you?
Back to the original question: Can
it
individually to determine if it is OnNet or OffNet before dialling it.
Douglas.
-Original Message-
From: Chris Albertson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 12:40 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Nested MySQL
On 11/01/06, 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.
I
instances of this script running (one per call).
Douglas.
-Original Message-
From: Peter Bowyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 1:36 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Nested MySQL Commands
On 11/01/06
Douglas Garstang wrote:
Peter, I assume you mean something like this in extensions.conf:
exten = _X.,1,AGI(master-dial-logic.pl)
and then there's only one call. All logic would be performed by
the perl script. This has many advantages. One disadvantage however
is that potentially, there
Daragon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 2:14 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Nested MySQL Commands
Douglas Garstang wrote:
Peter, I assume you mean something like this in extensions.conf:
exten = _X.,1,AGI
-Users] Nested MySQL Commands
Douglas Garstang wrote:
Peter, I assume you mean something like this in extensions.conf:
exten = _X.,1,AGI(master-dial-logic.pl)
and then there's only one call. All logic would be performed by
the perl script. This has many advantages. One disadvantage
Under Linux (and other OSes) It's not as bad as that. Even with
128 Perl processes running there is only one copy of the Perl
interpeter in memory. Each of the 128 running processes would
have it's own copy of only it's data segments. With Perl
already in memory the biggest system overhead
Douglas Garstang wrote:
jd but. but Asterisk still fires up a process
each time you make an AGI call in the dialplan. You could
still have 120 of these lightweight processes running,
in _addition_ to the other process. Doesn't sound like it
provides much benefit.
Or, you could
Users Mailing List - Non-Commercial Discussion
Cc: Douglas Garstang
Subject: Re: [Asterisk-Users] Nested MySQL Commands
Douglas Garstang wrote:
jd but. but Asterisk still fires up a process
each time you make an AGI call in the dialplan. You could
still have 120 of these lightweight
Chris Albertson wrote:
Under Linux (and other OSes) It's not as bad as that. Even with
128 Perl processes running there is only one copy of the Perl
interpeter in memory. Each of the 128 running processes would
have it's own copy of only it's data segments. With Perl
already in memory the
: [EMAIL PROTECTED]
Subject: Re: [Asterisk-Users] Nested MySQL Commands
Chris Albertson wrote:
Under Linux (and other OSes) It's not as bad as that. Even with
128 Perl processes running there is only one copy of the Perl
interpeter in memory. Each of the 128 running processes would
have it's own
-Users] Nested MySQL Commands
Chris Albertson wrote:
Under Linux (and other OSes) It's not as bad as that. Even with
128 Perl processes running there is only one copy of the Perl
interpeter in memory. Each of the 128 running processes would
have it's own copy of only it's data segments. With Perl
: Re: [Asterisk-Users] Nested MySQL Commands
Chris Albertson wrote:
Under Linux (and other OSes) It's not as bad as that. Even with
128 Perl processes running there is only one copy of the Perl
interpeter in memory. Each of the 128 running processes would
have it's own copy of only it's data
Douglas Garstang wrote:
So I really wish there was some way to measure how well the worst case scenario
would perform. This would be 120 simultaneous calls (don't know how many per
second) on a Dual 3.8Ghz Dell PowerEdge 1850 with 2GB RAM. Asterisk would call
an AGI script, written in perl,
Well, is Perl DBI thread-safe for a start???
-Original Message-
From: Leo Ann Boon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 5:32 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Nested MySQL Commands
Douglas Garstang wrote
29 matches
Mail list logo