I often get feedback on my articles, and try to respond either directly or via follow up posts. This is one of the reasons I have so many articles on pie charts (you only have yourselves to blame!) A few weeks ago I received an anonymous bit of feedback about the typewriter font I use […]
You can subscribe to the optimization tag micro-feed.
I have found that Activity Monitor can have a habit of bugging out on you when you try to get recent expensive queries. If you also get this, you may want to try the following query instead. You can adjust the query purposefully by changing the ordering, based on what you are looking for. There […]
I was listening to someone talking about being agile and lean in software development. The conversation was very interesting, but there was an underlying theme of urgency and efficiency that I found troubling. There is nothing wrong with delivering quickly, but we should never forget that “you can only go fast if you go right” […]
When I was working on SQL 2000 databases back in the day, the ordering of your joins and where clauses could make an insane difference to query performance. I was working on a reconciliation system that grew by a million records a month – so a simple re-order of a where clause would blast a […]
I have stuck with my trusty content management system for years, but the weight of content combined with the number of visitors has been causing page speeds to suffer a little recently. Average page load times have been landing in the 3 to 4 second mark, which sucks. So a tactical change was required to […]