python - Django 管理员 : Prefetch choices in list_editable

Question

我有一个模型 Domain我把它设置为 ForeignKey语言模型在 list_editable在 ModelAdmin .

问题是它导致了很多 SQL根据django_debug_toolbar查询.我以为我可以使用 select_related 解决它但它没有帮助，因为它只选择实际值，而不是所有选择。

@register(Domain)
class DomainAdmin(admin.ModelAdmin):
    list_display = ['id', 'name', 'main_url', 'language', 'max_depth', 'number_of_urls']
    list_editable = ['name', 'main_url', 'language', 'max_depth']
    list_select_related = ['language']

    #def get_queryset(self, request):
    #    return super(DomainAdmin, self).get_queryset(request).prefetch_related('language')

它仍然执行 SQL查询每个 Domain获取所有 Language对象。



如何让它一次性获取 Domain ?

Answer 1

Django-cachalot is especially efficient in the Django administration website since it’s unfortunately badly optimised (use foreign keys in list_editable if you need to be convinced).
https://django-cachalot.readthedocs.io/en/latest/introduction.html