2 ms·
I've used PostgreSQL, SQL Server, and MySQL. In my experience, MySQL had the worst query optimizer of the three. By A LOT. Basically, anything but a simple sel
by paulddraper 10y ago
I've used PostgreSQL, SQL Server, and MySQL.
In my experience, MySQL had the worst query optimizer of the three. By A LOT. Basically, anything but a simple select could suck very unnecessarily. Even for simple selects, MySQL messes up.
I've fixed more than performance issue by changing SELECT * FROM users WHERE key1 = 0 OR key2 = 5 into two queries and concatenating the results.