newrelic

photography of three dogs looking up

Optimizing Away a LEFT JOIN in a Pinch

SQL /

A couple years ago the company I worked for had had just launched a free consumer-facing application, and had been pushing it hard on social media. They were seeing hundreds to thousands of active users. It was painfully slow, and the culprit appeared to be the database. One of the main queries on the application was pushing the database server to its limits. Some users […]

Optimizing Away a LEFT JOIN in a Pinch Continue Reading »

Troubleshooting a Performance Problem Using NewRelic

Java /

Or, how to poorly implement adding css and javascript resources to a page One of the tools we use at work is the MagnoliaCMS. It powers some portions of some of our properties. For those who have not heard of it (I had not until a few years ago), think of it as WordPress, but more enterprise-y. Recently we noticed that some of the properties

Troubleshooting a Performance Problem Using NewRelic Continue Reading »