Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]
Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]
- Subject: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]
- From: Mike Schrag <email@hidden>
- Date: Thu, 3 Dec 2009 18:09:35 -0500
with MySQL 5, I don't think there's any reason to believe it's less of a database ... in particular, mysql's has an actual clustering implementation whereas pg has a failure pile in a sadness bowl.
http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL
this seems to be a reasonably up-to-date comparison
ms
On Dec 3, 2009, at 5:58 PM, Kieran Kelleher wrote:
> Miguel, anyone, please enlighten me as to what specifically is wrong with using MySQL InnoDB as a database for WO because I have not seen any problem, but then I have not used PostgreSQL or FrontBase either - so maybe I don't see a problem that I should be concerned about.
>
> -Kieran
>
> On Dec 3, 2009, at 5:41 PM, Miguel Arroz wrote:
>
>> Hi!
>>
>> On 2009/12/03, at 22:32, Kieran Kelleher wrote:
>>
>>>>> I create new OSCs for most background tasks. The one thing is that I dispose() on it at the end of the task .... and the dispose() is only useful if you use ERXJDBCAdaptor is used since the regular WO 5.3 jdbc adaptor opens two connections for every OSC and leaves the stupid things open forever. ERXJDBCAdaptor only opens one db connection and releases it when u call dispose() IIRC.
>>>>
>>>> Dude! <http://terminalapp.net/webobjects-postgresql-and-db-growing-and-growing/> ;)
>>>
>>> Dude! www.mysql.com - innodb (or cluster NDB) .... doesn't "grow and grow" (and it is not a "toy", no matter what Chuck says ;-) )
>>
>> No, it's a disaster! ;)
>>
>> The "growing" is a side effect of leaving the transaction opening that happens on PostgreSQL due to its architecture, but the point is the same, do what I say there to avoid the dumb connection. :)
>>
>> Yours
>>
>> Miguel Arroz
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden