SQL Server vs MySQL -Query execution time difference
I have migrated a large MS SQL Server database to MySQL. I have noticed that query execution for complicated queries with multiple joins on MySQL takes considerably longer compared to SQL Server for the same query(125.063 sec vs 0.01 sec respectively). What could be causing this?
SQL Server vs MySQL -Query execution time difference
===

I have migrated a large MS SQL Server database to MySQL. I have noticed that query execution for complicated queries with multiple joins on MySQL takes considerably longer compared to SQL Server for the same query(125.063 sec vs 0.01 sec respectively). What could be causing this?