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

5 votes417 views2 answers
My django template doesnt want to load the static file
Python Django
1 vote340 views1 answer
Django m2m .add
Python Django
6 votes402 views4 answers
Media django
Python Django
2 votes388 views2 answers
Django request.data
Python Django
0 vote341 views1 answer
Django get child element
Python Django
0 vote407 views1 answer
Django-mathfilters
Python Django
0 vote468 views1 answer
Request.build_absolute_uri django
Python Django
0 vote400 views1 answer
Float number field django models
Python Django
0 vote371 views1 answer
Styling filter form django
Python Django
3 votes352 views2 answers
Django radio button
Python Django