[Zenoss-dev] DB connection pooling testing

[Erik A. Dahl]

Hum ok let's talk about this more tomorrow.

-EAD

On Feb 21, 2007, at 6:24 PM, Marc Irlandez wrote:

>
> On Feb 21, 2007, at 5:44 PM, Erik A. Dahl wrote:
>
>> Marc,
>>
>> Looks good.  Will we ever use it this way?
>
> Yeah, I think we should use it this way going forward.
>
>> doesn't everyone call connect() on EventManagerBase?
>
> I've refactored the code to use the new way.
>
>> Does the code hide the pool?
>
> The code doesn't hide the pool, instead you would call the get and  
> put methods on the pool rather than the connect and close methods  
> the connection.
>
>>
>> -EAD
>>
>> On Feb 21, 2007, at 5:35 PM, Marc Irlandez wrote:
>>
>>> http://dev.zenoss.org/trac/wiki/HowToGetADBConnectionFromThePool
>>>
>>> On Feb 21, 2007, at 4:44 PM, Erik A. Dahl wrote:
>>>
>>>> Marc,
>>>>
>>>> Can you write a how to on using the new functionality and put it  
>>>> on dev?  Last thing we want is for people to be doing the wrong  
>>>> thing as they implement new functionality.
>>>>
>>>> -EAD
>>>>
>>>> On Feb 21, 2007, at 4:21 PM, Marc Irlandez wrote:
>>>>
>>>>> Devs,
>>>>>
>>>>> I've uploaded a changeset to the trunk that includes a  
>>>>> performance optimization...MySql DB connection pooling.
>>>>>
>>>>> Basically, a single synchronized pool (using Queue) of  
>>>>> connections is created holding 0 to n DB connections. They are  
>>>>> created when needed and placed into the pool when you are done  
>>>>> using them, thus avoiding the open and closing of connections  
>>>>> for any event related call.
>>>>>
>>>>> Since this change touches a bunch of files and affects a pretty  
>>>>> big piece of functionality, it would be good if everyone  
>>>>> downloaded it and tested.
>>>>>
>>>>> Let me know if you feel a difference.
>>>>>
>>>>> Marc
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> zenoss-dev mailing list
>>>>> zenoss-dev at zenoss.org
>>>>> http://lists.zenoss.org/mailman/listinfo/zenoss-dev
>>>>
>>>> _______________________________________________
>>>> zenoss-dev mailing list
>>>> zenoss-dev at zenoss.org
>>>> http://lists.zenoss.org/mailman/listinfo/zenoss-dev
>>>
>>> _______________________________________________
>>> zenoss-dev mailing list
>>> zenoss-dev at zenoss.org
>>> http://lists.zenoss.org/mailman/listinfo/zenoss-dev
>>
>> _______________________________________________
>> zenoss-dev mailing list
>> zenoss-dev at zenoss.org
>> http://lists.zenoss.org/mailman/listinfo/zenoss-dev
>
> _______________________________________________
> zenoss-dev mailing list
> zenoss-dev at zenoss.org
> http://lists.zenoss.org/mailman/listinfo/zenoss-dev