Re: Mysql seems MUCH slower than MSSQL
What is the MySQL version? How much RAM is available to MySQL?
In some versions of MySQL, the semi-join in(select...) is much slower than join on...
Let's see Show Create table for each of the two tables, plus the result of Explain on the query.
Subject
Written By
Posted
February 01, 2018 06:03PM
Re: Mysql seems MUCH slower than MSSQL
February 01, 2018 09:13PM
February 03, 2018 06:07AM
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.