django select_related for multiple foreign keys

django django-select-related
dtc picture dtc · Jan 17, 2013 · Viewed 16.9k times · Source

How does select_related work with a model which has multiple foreign keys? Does it just choose the first one?

class Model: fkey1, fkey2, fkey3...

The documentation doesn't say anything about this, at least not in where the method is specified.

NOTE: Maybe I'm the only one who will get confused. I guess select_related is just a performance booster (I can see that) but I had the wrong idea that it was something else.

Answer

Chemical Programmer picture Chemical Programmer · Dec 24, 2015

You can use select_related in a chain as following

Comment.objects.select_related('user').select_related('article').all()

Related questions

Django Query Related Field Count

I've got an app where users create pages. I want to run a simple DB query that returns how many users have created more than 2 pages. This is essentially what I want to do, but of course it's not the …

Read More
Django : select_related with ManyToManyField

I have : class Award(models.Model) : name = models.CharField(max_length=100, db_index=True) class Alias(models.Model) : awards = models.ManyToManyField('Award', through='Achiever') class Achiever(models.Model): award = models.ForeignKey(Award) alias = models.ForeignKey(Alias) count = models.IntegerField(default=1) …

Read More
Django ORM - select_related and order_by with foreign keys

I have a simple music schema: Artist, Release, Track, and Song. The first 3 are all logical constructs while the fourth (Song) is a specific instance of an (Artist, Release, Track) as an mp3, wav, ogg, whatever. I am having trouble …

Read More