Db_index django

This is not really django specific; more to do with databases. You add indexes on columns when you want to speed up searches on that column.

Typically, only the primary key is indexed by the database. This means look ups using the primary key are optimized.

If you do a lot of lookups on a secondary column, consider adding an index to that column to speed things up.

Keep in mind, like most problems of scale, these only apply if you have a statistically large number of rows (10,000 is not large).

Additionally, every time you do an insert, indexes need to be updated. So be careful on which column you add indexes.

As always, you can only optimize what you can measure - so use the EXPLAIN statement and your database logs (especially any slow query logs) to find out where indexes can be useful.

Source: stackoverflow.com

Similar codes

0 vote369 views1 answer
How to create urls in django
Python Django
1 vote407 views1 answer
Check if queryset is empty django template
Python Django
0 vote344 views1 answer
Django cleanup settings
Python Django
0 vote368 views1 answer
No module named 'bootstrap4' django
Python Django
0 vote342 views1 answer
Comment voir les requêtes SQL brutes exécutées par Django?
Python Django
0 vote345 views1 answer
Django allauth Reverse for 'password_reset_confirm' not found. 'password_reset_confirm' is not a valid view function or pattern name.
Python Django
-1 vote322 views1 answer
Django custom primary key field
Python Django
4 votes320 views1 answer
Django include
Python Django
0 vote327 views1 answer
Pass query params django template
Python Django
0 vote320 views2 answers
Get ContentType with django get_model
Python Django