4 ms·
MySQL prevents you from writing good SQL.. If you have a nice normalized schema, you will need to do joins, sometimes involving multiple tables and joining to
by justin_vanw 13y ago
MySQL prevents you from writing good SQL..
If you have a nice normalized schema, you will need to do joins, sometimes involving multiple tables and joining to sub selects. With MySQL, this is just a disaster, so you can't have a nice normalized schema, or if you do, you have to stash data in a denormalized way somewhere.
- xd 13y agoI've written just as complicated joins with MySQL as I have Oracle, PostgreSQL, SQL Server etc etc all with very similar performance. Can you provide/email me with some examples of what you are finding a "disaster" and I'll help find the flaws in the SQL or Schema, whichever it may be.