3 ms·
Atomic transactions, perhaps at the expense of pgsql being slower. Subqueries, but we don't require this in production. Wariness of Oracle's conflict of inter
by mmphosis 15y ago
Atomic transactions, perhaps at the expense of pgsql being slower.
Subqueries, but we don't require this in production.
Wariness of Oracle's conflict of interest.
- kristianp 15y agoMysql has had subqueries since version 4.1, circa 2004!
- mst 15y agoBut the optimiser is really bad at doing sensible things with them. Worse still, subqueries in the FROM clause are (documented to be) implemented as an unindexed temp table. Google apparently compiles subquery support out of their mysql instances so people don't mistakenly think they're usable.