How to efficiently sort a QuerySet?

Question

Django

Hello! There is a QuerySet that stores the number of likes for each group in the social network. The number of likes is initialized as a @property for the Django model. My task is to sort this QuerySet in descending order (most likes come first). I am using code like this:

sorted_groups = sorted(queryset, key=lambda g: (-g.posts_likes))

Everything works correctly, but very slowly. Can you please tell me how to optimize this sorting? The Django documentation states that iterator() can be sped up, is it worth digging in this direction?

Answer 1

Digging is in the direction of sorting by the DBMS. Your question has already been asked here .