MySQL Forums
Forum List  »  Stored Procedures

Re: optimizing the mysql plsql block
Posted by: Peter Brawley
Date: October 17, 2014 08:18AM

> clients says its slow on millions of records

?! Very slow indeed, since as written it can't run on MySQL. MySQL stored procedure language is not PL/SQL, see http://dev.mysql.com/doc/refman/5.7/en/create-procedure.html.

If you plan to port this code to MySQL, optimise the queries by themselves, and replace the cursors with simple selects.



Edited 1 time(s). Last edit at 10/17/2014 09:11AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
3040
October 17, 2014 12:16AM
Re: optimizing the mysql plsql block
1399
October 17, 2014 08:18AM
1600
October 18, 2014 02:17PM


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.