Re: Lion and WO
Re: Lion and WO
- Subject: Re: Lion and WO
- From: Johann Werner <email@hidden>
- Date: Fri, 29 Jul 2011 16:00:20 +0200
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