Have you had experience improving the efficiency of queries in Django projects?

Yes, to improve query efficiency in Django, I often apply ORM query optimization methods. For example, I use select_related for eager loading of related objects through foreign keys, which reduces the number of SQL queries. I also use prefetch_related to optimize fetching related objects through many-to-many or reverse relations.

It's also important to avoid unnecessary queries in loops and to use aggregations and annotations for computations at the database level.

Example:

# Poor practice: makes queries inside a loop
for book in Book.objects.all():
    print(book.author.name)

# Optimized version with select_related
books = Book.objects.select_related('author').all()
for book in books:
    print(book.author.name)

It is also useful to profile queries using django-debug-toolbar or connection.queries to identify bottlenecks.