Re: Mysql seems MUCH slower than MSSQL
1) Your table `TABLE 126` doesn't have any index on email so no wonder the join with the IN clause is slow!
2) Email is defined as CHAR(36) in one table and VARCHAR(100) in the other : usually, try to keep the same things with the same type and size, it helps a lot.
3) Creating an index on email for `TABLE 126` would help but depending on your version of MySQL, an index on (email, status) would be even better
4) Instead of using a CHAR(15) for status, an enum would be a lot more efficient otherwise you're forcing a string comparison (instead of a very fast integer comparison)
5) If MySQL was that slow, Facebook wouldn't run on it behind the scene... ;)
Subject
Written By
Posted
February 01, 2018 06:03PM
February 01, 2018 09:13PM
February 03, 2018 06:07AM
Re: Mysql seems MUCH slower than MSSQL
February 03, 2018 06:49AM
February 03, 2018 07:41AM
February 03, 2018 10:04AM
February 03, 2018 10:16AM
February 03, 2018 12:17PM
February 03, 2018 02:35PM
February 03, 2018 07:25PM
February 04, 2018 11:14AM
February 04, 2018 12:22PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.