How to properly work with Django ORM?

Question

Django

Recently I came across: https://habrahabr.ru/post/175727/ and I had a question: after 5 years, something has changed in the ORM, or is it still necessary to write optimized queries, as described here?
Please tell me, sites, forums or similar questions, where else it would be described how to optimize queries to the database.

Answer 1

You should strive to know the tool you are using better. And the better you know how Django ORM works, the more you can write the optimal query and the more you can determine when optimization is needed and when it is not. But in no case should you use "magic" optimizations, about which you read somewhere, but you yourself do not understand how and why they work.