[Asterisk-Users] Nested MySQL Commands

[Douglas Garstang]

I wouldn't know where to begin to look to research how to write a new Asterisk application command. We're not all C programmers. For now, my AGI script is in perl.

-----Original Message-----
From: John Daragon [mailto:john at argv.co.uk]
Sent: Wednesday, January 11, 2006 3:02 PM
To: Asterisk 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 processes running,
 > in _addition_ to the other process. Doesn't sound like it
 > provides much benefit.

Or, you could have the dialplan pass control to
app_<access_the_database> and have that do the data manipulation,
populating dial plan variables for processing as usual (or,
I guess, performing the routing itself).

No process overhead.  I'd still be inclined to use a pool of running,
connected database processes/threads to handle the actual queries.

jd

-- 

John Daragon                                          john at argv.co.uk
argv[0] limited               (Asterisk implementation & consultancy)
Lambs Lawn Cottage,  Staple Fitzpaine,  Taunton,  TA3 5SL,  UK
v +44 (0) 1460 234068   f +44 (0) 1460 234069   m +44 (0) 7836 576127