It lacks stored procedures, yes. But that's certainly just the top it. I wouldn't even call it a real DBMS, as it lacks almost all advanced features: Transactions (begin, commit and rollback), simple sub-selects (or is that included nowadays?), referential integrity, triggers, and I could go on.
But it's fast (due to the smaller scale), I'll have to admit that. But to compare the speed of MySQL to the large enterprise DBMS's is simply unfair as MySQL serves a different purpose.
Slashdot Mirror
My point was that MySQL not only lacks transactions and sp's, it also lacks quite a few other features which are commonly used by other (real) DBMS's.
But as far as the possibily to turn off support for transactions, I think you're absoluty right.
It lacks stored procedures, yes. But that's certainly just the top it. I wouldn't even call it a real DBMS, as it lacks almost all advanced features: Transactions (begin, commit and rollback), simple sub-selects (or is that included nowadays?), referential integrity, triggers, and I could go on.
But it's fast (due to the smaller scale), I'll have to admit that. But to compare the speed of MySQL to the large enterprise DBMS's is simply unfair as MySQL serves a different purpose.