MySQL Forums
Forum List  »  Stored Procedures

Proc Slow in Mysql Fast in MSSQL
Posted by: Scott Thompson
Date: June 25, 2014 07:28AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Proc Slow in Mysql Fast in MSSQL
1840
June 25, 2014 07:28AM


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.