[Asterisk-Users] Re: Nested MySQL Commands

[Mike Fedyk]

Connection pooling doesn't require threading.

You can also use a pool of processes which are quite cheap on Linux.

Douglas Garstang wrote:

>Do you have a link to where it says this? The DBI docs that I looked at (perldoc dbi) said that it isn't thread-safe.
>
>-----Original Message-----
>From: Leo Ann Boon [mailto:leo at datvoiz.com]
>Sent: Thursday, January 12, 2006 12:50 AM
>To: Asterisk Users Mailing List - Non-Commercial Discussion
>Subject: Re: [Asterisk-Users] Re: Nested MySQL Commands
>
>
>Douglas Garstang wrote:
>
>  
>
>>I also don't believe perl DBI is thread safe....
>> 
>>
>>    
>>
>The lastest docs says that DBI does support multithread connection 
>pooling. Otherwise, you are always free to implement your AGI in 
>'modern' :) programming languages like Java or C# that support threads 
>and pooling.
>
>  
>
>>	-----Original Message----- 
>>	From: Douglas Garstang 
>>	Sent: Wed 1/11/2006 9:08 PM 
>>	To: Asterisk Users Mailing List - Non-Commercial Discussion 
>>	Cc: 
>>	Subject: RE: [Asterisk-Users] Re: Nested MySQL Commands
>>	
>>	
>>	Since about 1992... and the Asterisk docs for FastAGI are pretty rotten. But that's ok, I've come to expect that.
>>
>>		-----Original Message----- 
>>		From: Kevin P. Fleming [mailto:kpfleming at digium.com] 
>>		Sent: Wed 1/11/2006 8:11 PM 
>>		To: Asterisk Users Mailing List - Non-Commercial Discussion 
>>		Cc: 
>>		Subject: Re: [Asterisk-Users] Re: Nested MySQL Commands
>>		
>>		
>>
>>		Douglas Garstang wrote:
>>		> I don't get the whole concept of FastAGI. It's nothing special. Asterisk just opens a connection to a TCP port instead of executing a binary.
>>		
>>		How long have you been around Unix/Linux systems? Do you have any clue
>>		how much less expensive it is to open a TCP socket as compared to
>>		forking the Asterisk process, exec()-ing another program, having that
>>		program open database/web connections, etc.?
>>		_______________________________________________
>>		--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
>>		
>>
>> 
>>
>>------------------------------------------------------------------------
>>
>>_______________________________________________
>>--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
>> 
>>
>>    
>>
>
>_______________________________________________
>--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
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>--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
>  
>