Re: optimizing the mysql plsql block
> 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.
Subject
Views
Written By
Posted
3040
October 17, 2014 12:16AM
Re: optimizing the mysql plsql block
1400
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.