Discussion

Jurrian Tromp

Freelance Webdeveloper

Jan 11, 2023

Reducing queries for ForeignKeys in Django admin inlines

Speed up with raw_id_fields ForeignKeys in the Django admin show as a select-box (<select>) by default. This will result in a query for every item in the select, only to get the name. This is not a problem if the model you're referencing will always ...

deepintodjango.com3 min read

#django #prefetching #optimization #performance #python

Responses(1)

A

Ander

Aug 4, 2023

I am having performance issues because of the inlines, I am really curious about your solution, but is it just for Django v4? that way of defining inlines = ["some-inline"] as strings doesn't look familiar, shouldn't that be classes instead?

AFAIK this is applies to all Django versions. You are right that they should be classes instead. It might be that as a string it still works as lazy loading, so probably both work. The key of the problem is how the Django internals work in such a way that it creates a lot of extra queries.

JT

Jurrian Tromp

Freelance Webdeveloper

Aug 19, 2023

Search Hashnode

Reducing queries for ForeignKeys in Django admin inlines

Responses(1)