Optimize code

Transaction tracing helps developers optimize their code as they write it

Matt Watson Developer Tips, Tricks & Resources

The best time for developers to optimize their code is while they are writing it. Developers can leverage the detailed transaction tracing available from APM type tools, like Prefix, as a fast feedback loop to understand what their code is doing and how long it takes. Prefix works as an ASP.NET profiler and also works with several common JVMs for Java.

Transaction tracing is a critical feedback loop for developers

“When informed about a problem whilst in the moment I’m in a much better position to make corrections or come up with alternative solutions. Without a quick feedback loop, the passing of time makes it difficult to get into the initial mindset which caused the problem to begin with.”Vince Panuccio

Lightweight code profilers and other data collect methodologies can be used to provide developers a wealth of information about what their code is doing. Including logging statements, errors, SQL queries, web services, and other dependencies.

Today’s applications are complex and typically connect to multiple dependencies like SQL & NoSQL databases, PaaS services, mongodb, elasticsearch, redis, queueing, and many other services. Prefix helps developers instantly understand if their code is using them correctly and how they impact the performance of their app.

Example transaction trace captured by Prefix


As an example, developers can find common problems like N+1 database query patterns caused by SQL queries being ran in a loop. Prefix’s built in suggestions highlights a potential problem and the 38 database queries becomes a glaring problem.


This instant feedback can help developers validate that their code is doing what they expected it to do. Profiling and performance tuning is something developers don’t typically do until the tail end of a project. Most of the time, they don’t even do it unless there is a known performance issue in the code or they are doing stress testing.

By using tools like Prefix, developers can continually be looking for performance problems in their code as part of their natural development process. The transaction tracing that developers can get from these types of free tools is a must have.


About Matt Watson

Matt is the Founder & CEO of Stackify. He has been a developer/hacker for over 15 years and loves solving hard problems with code. While working in IT management he realized how much of his time was wasted trying to put out production fires without the right tools. He founded Stackify in 2012 to create an easy to use set of tools for developers.