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 [...]
March 28th, 2008 | by clong | published in Tips, Well.ca
Yesterday, Alex, who handles marketing at Well.ca, asked for a list of top 50 rural customers in Canada. “Easy!” was my reply, then I thought about it. How to do it? Maybe if I get a list from Canadapost with all the postal codes and their population density I can use that. Maybe I can [...]
If you like the content of this website and are looking for a way to be notified of new content, look no further. Just click the orange icon to your right and subscribe using your favorite feed reader.