Optimizing SQL Select: Using ‘IN’ in MySQL
April 10th, 2008 | by clong | published in Tips
I’ve known for a bit that using the ‘IN’ condition for MySQL queries is much much slower then it should be. I didn’t realize how much will I was browsing the website Common Queries for MySQL and came across the section called The unbearable slowness of IN().
According to this page, using IN is two times [...]
