MySQL Forums
Forum List  »  Stored Procedures

Re: Slow stored procedure call
Posted by: Rick James
Date: August 01, 2013 10:24PM

SHOW CREATE PROCEDURE GetUrl;
I think you will find a character set issue that leads to a table scan.
Even if you get past the CHARACTER SET, you may have COLLATION problem.

One workaround is to use BINARY instead of CHAR for the hash -- both in the table definition and the procedure definition.

Options: ReplyQuote


Subject
Views
Written By
Posted
8822
July 30, 2013 07:48PM
Re: Slow stored procedure call
2893
August 01, 2013 10:24PM
2521
August 19, 2013 10:24AM


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.