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 vote236 views1 answer
Django auto increment field
Python Django
31 votes290 views6 answers
Django admin create superuser
Python Django
0 vote245 views1 answer
App is not a registered namespace django
Python Django
0 vote221 views1 answer
How to use django-rest-framework-datatables
Python Django
3 votes254 views1 answer
Django user group check
Python Django
0 vote241 views1 answer
?: (admin.W411) 'django.template.context_processors.request' must be enabled in DjangoTemplates (TEMPLATES) in order to use the admin navigation sidebar.
Python Django
0 vote237 views1 answer
Django-multivaluedictkeyerror-error
Python Django
4 votes240 views3 answers
No such table: django_session
Python Django
1 vote244 views1 answer
Difference between get and filter in django
Python Django
0 vote212 views1 answer
Remove last comma forloop django
Python Django