SQL Optimization: a comprehensive developer’s guide
A SQL optimization guide for developers. With best practices, warnings, pro tips to speed up your SQL optimization.
Tag: optimization
How to speed up COUNT(DISTINCT)
While counting is common in every application, sometimes it is not enough: when we need to display the amount of unique users generating traffic in our website or provide the number of disparate items included in an order we need to apply a distinct count. Compared to a classical count, the distinct one is usually… Continue reading How to speed up COUNT(DISTINCT)
How to print Prisma raw SQL query and optimize it
In modern application development, we often abstract direct access to the database layer from the application layer using an ORM. This allows us to worry less about exactly how the data is retrieved using SQL, and more about writing our application. That said: there are scenarios where it’s useful to examine and optimize the underlying… Continue reading How to print Prisma raw SQL query and optimize it