3 ms·
I have used MySQL and Oracle and I have found MySQL to be more reliable, more performant, easier to configure, and easier to develop against. I believe that in
by ilaksh 13y ago
I have used MySQL and Oracle and I have found MySQL to be more reliable, more performant, easier to configure, and easier to develop against.
I believe that in 80-90+% of the cases where Oracle is deployed, it is only still being used because business executives are out of touch and don't want to admit that the massive investments they committed their companies to are no longer required.
- cmccabe 13y agoMySQL's query optimizer is a joke compared to Oracle's. If you don't do joins and just use it as a key-value store, that doesn't matter. MySQL also doesn't enforce most SQL constraints like "can't store a string in an int field" etc.
- ilaksh 13y agoWow, that's interesting if the SQL constraints are all completely ignored.. seems doubtful. My experience with Oracle's query optimization was that it was non-intuitive to configure to work correctly especially with the way that the optimizer statistics config works. MySQL will do quite useful query optimization (for joins) if you have appropriate indexes. So I think that in 80% of cases that is what matters in both Oracle and MySQL -- creating appropriate indexes. Honestly I don't think you know what MySQL is capable of.
- flyinRyan 13y ago>I have used MySQL and Oracle and I have found MySQL to be more reliable, more performant, easier to configure, and easier to develop against. Then you're simply not an enterprise level developer. Oracle is, to this day, one of the most powerful databases out there. Granted, they have absolutely awful interface tools (which is why most people are reduced to using a buggy 3rd party app to do common DB work on Oracle), but the Database itself is world class. MySQL isn't really a competitor. It competes better with things like SQLight.