Nobody likes a slow application or a website. Not only can it frustrate your users, but it can also directly affect your business metrics, such as conversion rates. Without proper care, your application can easily slow down as your project grows.

One of the most common sources of slowdowns is your database. Django ORM makes it easy to work with databases, but it also makes it easy to forget how to use it properly.

In this talk, you will learn how to measure and diagnose database operations in your Django app, fix common issues, and leverage your database engine's features to unleash its full potential. We will cover topics such as N+1 queries, creating and using database views from Django, database indices and EXPLAINing queries (I’ll keep it easy to understand, I promise!).

While the session focuses on Django apps, most of the topics also apply to SQLAlchemy and other libraries.

After the talk, you will know how to diagnose database query performance and have a good understanding of how to fix common performance bottlenecks.

You’ll need basic knowledge of the Django ORM or a similar tool like SQLAlchemy, as well as general database concepts.