Python Django ORM - Towards SQL Optimization - Django Debug Toobar Package

Thinking more serious about Python Django means understanding a little more about the performance of our django application. As you might imagine there are many tools and methods to measure performance. Moving into that direction the django-debug-toolbar give us provide some useful information to help us start thinking about database/SQL optimizations.

Django as a powerful framework makes it easy to interact with database - allows you to directly map your object-oriented models to database table structures and in doing so also builds the data and table relationships.

This level of abstraction the ORM provides (although it does a great job) it can cloud our understanding the performance of our application. And as better performance can convert to lower running costs – its an important aspect of our development we need to know more about.

Starting your journey to database optimization, we need to understand what is happening behind the scenes or more importantly monitor SQL performance. If you have seen the other tutorials in this series we already know that we can collect information about SQL queries that be being executed. In this tutorial, although there are many various ways to log SQL queries, here we take a look at the package django-debug-toolbar – which as you will see provides more than just SQL information. Overall, it provides us some great insights into our application.

✨ Support us - join us as a very academy member
https://www.youtube.com/channel/UC1mxuk7tuQT2D0qTMgKji3w/join

?SUBSCRIBE to get more free tutorials, courses and code snippets!
http://www.youtube.com/channel/UC1mxuk7tuQT2D0qTMgKji3w?sub_confirmation=1

??Follow us on Facebook
https://www.facebook.com/Veryacademycom-113232103670580/

???Follow use on Twitter:
https://twitter.com/VeryAcademy