Using the select_related() method
The select_related()
method is used as a performance booster on queries pertaining to all related ForeignKey
and OneToOneField
relationships. This method is primarily used for obtaining the data of single objects that relate to a parent object. This method will not work on ManyToManyField
relationships. On the SQL level, this method generally uses a left outer join to look up related data. To learn more about the select_related()
method in its entirety, visit https://docs.djangoproject.com/en/4.0/ref/models/querysets/#select-related.
Here, we will monitor the performance of a page that displays a list of vehicles and the details about each vehicle, including related field data. Use the following subsections to create the required view class, template, and URL pattern to demonstrate this concept in action.
Creating the view
Follow these steps to create your VehicleView
class:
- In your
/chapter_10/views.py
file, add the followingVehiclesView...