Re: Slow stored procedure call

[Bill Gladstone]

Table scans weren't occurring, but there was definitely a problem with the character set and collation of the HashedUrl column. Changing the column from CHAR(32) to BINARY(16) and using UNHEX() to convert the MD5 hash from a character string to binary fixed the problem for me.

If anyone else runs into this, the "Encryption and Compression Functions" topic at http://dev.mysql.com/doc/refman/5.6/en/encryption-functions.html describes how to efficiently store and index hashed values.

Many thanks for the solution, Rick.

-- Bill



Edited 1 time(s). Last edit at 08/19/2013 10:25AM by Bill Gladstone.