Re: Lion and WO
Re: Lion and WO
- Subject: Re: Lion and WO
- From: Ramsey Gurley <email@hidden>
- Date: Fri, 29 Jul 2011 07:41:09 -0700
I don't think it would be a property. That would just be the correct behavior. I wasn't aware of such syntax when I wrote the initial MySQL plugin for wonder, or I would have certainly included this. I dug through the manual trying to solve this problem but never found the answer.
I don't use MySQL anymore tho, so if you want it fixed, submit a patch/pull request.
Ramsey
On Jul 29, 2011, at 7:00 AM, Johann Werner wrote:
>
> Am 29.07.2011 um 12:54 schrieb Lachlan Deck:
>
>> What are the replication possibilities these days for dbs such as Postgres et al?
>> Part of the success of MySQL I gather is having this support.
>>
>> We unfortunately use MySQL where I'm working, and it certainly struggles for certain things. One of the things that kills mysql as well is refactoring on large tables. e.g., adding columns causing a full table copy etc. This has been fixed apparently in 5.5.
>>
>> So far as poor indexing usages, WO by default doesn't help for case-insensitive searches by its usage of "like UPPER(..)" which bypasses mysql indexes altogether. I don't know if more recent Wonder mysql adaptors help with this but I'd created a custom adaptor for mysql that essentially did the following:
>> - for case-insensitive: ... a like 'Foo'
>> - for case-sensitive: binary a like 'Foo'
>
> where is the commit for the current MySQL plugin and the corresponding property to switch to the new behavior? ;-)
>
>
>>
>> Lachlan Deck
>> email@hidden
>>
>> <snip>
>>
>
> _______________________________________________
> 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
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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