Hi Baron,
On 21/09/2008, at 2:17 PM, Baron Schwartz wrote:
Apps built for the cloud (sharding, etc etc) have very little use for
foreign keys, cross-engine or not. This is a reality that hits some
people pretty hard. The realization that you have to give up on them
is like losing your favorite snuggly blanket.
I'd kind of like to rip them out of InnoDB, but I don't want to touch
all that code. It's very scary. I'd call it the ugliest part of
InnoDB's beautiful code, but there might be something uglier, I don't
know. Indexing support itself is a little scary :) Who else on this
list knew that InnoDB has a built in SQL parser and stored procedure
language and writes itself SQL commands sometimes when it needs to do
DDL operations?!?!?
/me raises hand.
And it's been a pest in the past, with differences in quoting
behaviour, for instance.
There've been bugs on it.
The stored proc stuff was there from before the MySQL integration, I
believe it was for testing purposes.
Cheers,
Arjen.
--
Arjen Lentz, Founder @ Open Query
Training and Expertise for MySQL in Australia and New Zealand
http://openquery.com.au/training/ (ph. +61-7-3103 0809)
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
