Re: MyISAM and Webobjects
Re: MyISAM and Webobjects
- Subject: Re: MyISAM and Webobjects
- From: Kieran Kelleher <email@hidden>
- Date: Mon, 29 Oct 2012 21:40:20 -0400
Anecdotally, it seems modern 5.5 InnoDB should be faster than MyISAM and especially so if enough memory is available ..... InnoDB uses available memory to cache/buffer entire records of data whereas last time I read about this, MyISAM only caches Primary Keys in memory and other MyISAM fields' data still remains on disk.
If your entire database is 80GB and you have a 96GB server, then the entire database could eventually be paged into be in RAM as it is fetched.
On Oct 29, 2012, at 9:26 PM, Lachlan Deck <email@hidden> wrote:
> The one exception to this I can think of is read-only data, for really large data sets where the speed of reads is paramount. But you'd only go for such a thing as a last resort, to avoid the premature optimisation syndrome.
>
> On 30/10/2012, at 10:23 AM, Ramsey Gurley <email@hidden> wrote:
>
>> MyISAM is not ACID. WO was designed around the concept of ACID transactions with highly consistent data.
>>
>> http://www.julianbrowne.com/article/viewer/brewers-cap-theorem
>>
>> Ramsey
>>
>> On Oct 29, 2012, at 3:09 PM, Gino Pacitti wrote:
>>
>>> Hi list
>>>
>>> I read in the wiki a reference to WO not using MyISAM in tables but no explanation why - any pointers to an explanation.
>>>
>>> Gino
>>> _______________________________________________
>>> 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
>
>
> _______________________________________________
> 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