Demystifying Database Performance Issues with sqlcommenter - Jan Kleinert & Bala Chandrasekaran
Channel: OpenJS Foundation
Date: 02/06/2021

Have you ever tried to troubleshoot a database performance issue in an application that was built using an ORM? ORMs can simplify development of applications that communicate with databases, but since the ORMs are generating the SQL statements, it can be difficult to determine which application code is resulting in slow queries. sqlcommenter is an open source library that enables ORMs to augment SQL statements with comments about the about the code that caused its execution, making it easier to correlate your application code with the SQL statements that were generated by the ORM. In this session, Jan and Bala will demonstrate how to set up and use sqlcommenter with an application that uses Sequelize.js to diagnose query performance. They'll also touch on the other frameworks and ORMs that sqlcommenter supports as well as how you can view this data in db logs and observability tools.