MySQL Forums
Forum List  »  Stored Procedures

Re: Use of stored procedures and functions
Posted by: Peter Brawley
Date: September 25, 2017 01:48PM

Three args against ...

1 Up to version 5.7 at least, MySQL sprocs do not generally improve performance

2 MySQL has no arrays, you'd have to use pseudoarray strings or memory tables

3 There's not a good sproc debugger

To me, it sounds like a nightmare sproc.

Options: ReplyQuote

Written By
Re: Use of stored procedures and functions
September 25, 2017 01:48PM

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.