MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Very different behaviour executing stored procedures between 5.5 and 5.7
Posted by: Peter Brawley
Date: February 16, 2017 01:31AM

> MySQL 5.7 seems to return a result set from a stored procedure as soon as a select statement is encountered and doesn't wait until the stored procedure completes.

Has always done so IIRC.

> performance is much much slower. Stored procedures that used to execute almost instantaneously are now taking many seconds to execute.

I haven't seen such a performance dip. Please provide a test case I can run against 5.5 and 5.7, showing something of the difference you observe.

> Tests were performed in isolated VMs

Did you run the same tests in a native OS environment? What host & guest OSes?



Edited 1 time(s). Last edit at 02/16/2017 02:10PM by Peter Brawley.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Very different behaviour executing stored procedures between 5.5 and 5.7
3638
Daniel Bradley
February 15, 2017 10:43PM
Re: Very different behaviour executing stored procedures between 5.5 and 5.7
765
Peter Brawley
February 16, 2017 01:31AM
Re: Very different behaviour executing stored procedures between 5.5 and 5.7
940
Daniel Bradley
February 17, 2017 06:34PM
Re: Very different behaviour executing stored procedures between 5.5 and 5.7
676
Peter Brawley
February 17, 2017 08:13PM


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.