1: Use Select Related and Prefetch Related:
Django provides two handy methods for optimising queries involving ForeignKey and OneToOneField relationships: select_related and prefetch_related. These methods enable you to get related objects more efficiently, lowering the number of database searches.

# Example using select_related

queryset = MyModel.objects.select_related('related_model')

# Example using prefetch_related

queryset = MyModel.objects.prefetch_related('related_set')

https://erpsolutions.oodles.io/developer-blogs/Proven-Techniques-fo...