When Using CharField in Django Admin list_filter, Adding Choices Makes It Faster

2021-03-30 12:05 (4 years ago)
日本語で表示
When Using CharField in Django Admin list_filter, Adding Choices Makes It Faster

When specifying a CharField in list_filter in Django Admin,

if choices are not specified for that CharField, it fetches all existing values of all records using DISTINCT, which can be quite slow without an index.

In such cases, if it is possible to specify choices, doing so will eliminate the need for SQL queries and significantly speed up the process.

Currently unrated
The author runs the application development company Cyberneura.
We look forward to discussing your development needs.
View Cyberneura
Latest Articles

Recent Posts

Recent Deliverables

Categories

Archive

2026
February (6)January (4)
2025
August (2)July (1)May (3)April (1)March (2)January (1)
2024
December (2)September (1)July (3)June (3)May (2)April (1)March (2)February (1)January (1)
2023
December (3)November (2)October (2)September (1)August (3)July (3)June (1)May (5)April (2)March (4)February (1)January (4)
2022
December (3)November (6)October (5)September (10)August (3)July (2)June (4)May (1)April (3)March (1)February (1)January (2)
2021
December (7)November (4)October (3)August (4)July (1)June (1)March (7)February (7)January (6)
2020
November (3)October (2)September (1)August (1)July (3)June (1)May (3)February (1)January (2)
2019
December (2)September (2)July (1)June (3)May (1)March (2)February (2)
2018
December (1)October (1)September (8)August (2)July (3)June (2)May (3)March (2)February (6)January (4)
2017
December (2)October (1)September (4)August (2)June (2)May (3)April (2)March (6)February (6)January (2)
2016
September (3)June (1)January (1)
2015
December (5)November (2)October (5)September (4)August (4)July (2)June (5)May (3)March (1)
2014
June (6)May (1)April (4)March (1)February (1)January (2)
2013
November (3)October (1)September (4)August (3)
2012
March (1)
2011
December (1)September (2)July (1)June (23)