Performant SQL
| July 1st, 2011This query performs amazingly on a table with 8 million rows:
SELECT `id`, `account`, `post` FROM `subscribers` WHERE MD5( CONCAT( account, post, email ) ) = '8ada1291a95d8919ba80f2d00167b86f' LIMIT 1;
This query performs amazingly on a table with 8 million rows:
SELECT `id`, `account`, `post` FROM `subscribers` WHERE MD5( CONCAT( account, post, email ) ) = '8ada1291a95d8919ba80f2d00167b86f' LIMIT 1;