PropertyMaps Corporate Blog

Oh, around the end of April, we made some enhancements to our DB structure and our queries. This round of changes focused on the JOINS and UNIONS and COUNTS and some others, giving us a nice speed boast in our benchmarks. We thought not much of it and went on to other things. Logging in to Google Webmaster Central gave me quite a shock when I saw the chart for time spent downloading a page (in milliseconds). We’ve gone from an average of about 4,300 milliseconds to less than 400, an order of magnitude difference!

We have another trick up our sleeve, but need to do an intense code review and QA before pushing it out to production. This other trick is a tad more complicated, but watching the site run on the dev server is amazing. Hopefully, we can wrap that optimization up and get it live shortly. I’ll probably blog about it when we do.

Go Servers, Go