MySQL Forums
Forum List  »  Stored Procedures

Re: Are stored procedures faster/better then simple queries?
Posted by: Peter Brawley
Date: May 31, 2013 11:25PM

As Rick says, in circumstances where one sproc call saves you multiple long distance calls to another server, an sproc can improve performance. Even that, though, can cause problems of its own, eg some APIs (eg PHP) have trouble with an sproc that executes multiple queries, so you pretty much have to dismantle the sproc.

IOW in MySQL encapsulation ain't free.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Are stored procedures faster/better then simple queries?
4193
May 31, 2013 11:25PM


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.