Django: Force select related?

Question

I've created a model, and I'm rendering the default/unmodified model form for it. This alone generates 64 SQL queries because it has quite a few foreign keys, and those in turn have more foreign keys.

Is it possible to force it to always (by default) perform a select_related every time one of these models are returned?

question from:https://stackoverflow.com/questions/4892729/django-force-select-related

Answer 1

You can create a custom manager, and simply override get_queryset for it to apply everywhere. For example:

class MyManager(models.Manager):
    def get_queryset(self):
        return super(MyManager, self).get_queryset().select_related('foo', 'bar')

(Prior to Django 1.6, it was get_query_set).