March 2nd, 2010 | by clong | published in PHP, Tips, Web Development
With all the brilliant tools (Google Page Speed, YSlow, etc.) out there, web professionals can now easily see a few basic things to improve page speed performance. One suggestion is to send static content from a cookieless domain. On most sites I’ve worked with, we serve static content from a media subdomain and then the [...]
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 [...]