Databases
StackOverflow2013
Postsdbo
PODjango admin change-list optimizing query: select field1, field2 instead of select *
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODjango admin change-list optimizing query: select field1, field2 instead of select *
    text
    copied!<p>I have a large horizontal table (30 fields) with quite a few foreign keys (each averaging upto 10 fields). While displaying the table in the Django admin, I use select related to optimize and avoid multiple querying. What I am looking for is to ensure that only my list_display entries are retrieved and not all the 30 fields + (foreign keys X 10) fields. Currently a select * on the table + a select * on all the join fields run. Basically, a way to get 'values' at the Django admin level. Thanks.</p> <p>Edit: An example below:</p> <pre><code>class X(models.Model): x1 = models.IntegerField # needed for admin display x2 = models.TextField # needed for admin display x3 = models.ForeignKey(Y) x4 = models.ForeignKey(Z) ... # X5 to x30 are not needed for admin display X30 = models.Integerfield @property def y1(self) : return self.x3.y1 @property def y2(self): return self.x4.z1 class Y(models.Model): y1 = models.IntegerField # needed for admin display ... y10 = models.IntegerField class Z(models.Model): z1 = models.IntegerField # needed for admin display ... # z2 to z10 are not needed for admin display z10 = models.IntegerField **admin.py** list_display = ['x1', 'x2', 'y1', 'z1'] </code></pre> <p>My problem is when I look at the query generated to display this, it does a select * on X(x1 to x30), and using select_related, it extracts y1 to y10 and z1 to z10, even though I do not need all fields. </p> <p>This table is heavily used as a CRM and it is currently a showstopper because of the slow query that is generated. There are also blobs and huge varchars, which are not used for the display and still being queried. </p> <p>Thanks.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload