Room: Baltic II+III
Bad SQL is one of the most common performance issues. The use of ORM frameworks and treating a database as a data store only leads to slow queries which slow down the whole system. I’ll discuss some basic techniques every developer should be aware of, along with some examples from production systems of query tuning using different approaches from modifications of joins and subqueries to adjusting the planer cost settings and other parameters that affect the way a query is executed. Besides, I’ll present some techniques to benchmark a query performance in a reliable and automated manner.
The following slides have been made available for this session: