Quote:
Originally posted by bstjean
Well, MySQL handles transaction now with the InnoDb handler (which comes standard now). So there's not problem on that side and for read-only stuff, nothing is as fast as MyISAM tables (expect Oracle). The only thing missing now are views... But it's coming soon...
|
Ahem, transactions work *only* if all tables involved are InnoDB. Most of the other features only work on MyISAM tables. Since the only way to use MyISAM safely is with locks, the speed advantages are false.
And, please, I've heard enough promises about all the wonderful features that are "coming in the next release... we promise!" MySQL will offer views... but will they be crippled the way transactions are? What limits will there be on updatability? Will they only work on certain table types?
4.1 is still alpha, and you act like a 5.0 beta is out. I don't demand that everyone be a ruthless skeptic, but at the same time, some of you guys sound like
PR flacks.