MySQL Forums
Forum List  »  Newbie

Re: Mysql seems MUCH slower than MSSQL
Posted by: Benoit St-Jean
Date: February 03, 2018 06:49AM

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... ;)

Options: ReplyQuote


Subject
Written By
Posted
Re: Mysql seems MUCH slower than MSSQL
February 03, 2018 06:49AM


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.