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 > lachlan.d...@gmail.com > > <snip> > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
