Proc Slow in Mysql Fast in MSSQL
I copy a MySql DB into MSSQL every night by reading information_schema and copying all tables, indexes and Keys.
We have a proc in MySql that takes 35 minutes to run. I created the the proc in MSSQL and it take 5 sec.
I am new to MySQL, What could be causing this? The procs are identical, as in same selects same temp tables same cursors.
Subject
Views
Written By
Posted
Proc Slow in Mysql Fast in MSSQL
1841
June 25, 2014 07:28AM
1254
June 25, 2014 10:53AM
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.