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 vote252 views1 answer
Crawling emails with python
Python
2 votes277 views1 answer
List of tkinter bindings
Python
30 votes252 views3 answers
How to iterate through files in a folder python
Python
-1 vote385 views4 answers
Flask documentation
Python Flask
0 vote266 views1 answer
Python divide string in half
Python
0 vote253 views1 answer
Argmax change dafault value for multiple maxima
Python
0 vote286 views1 answer
Get list of all document in django-elasticsearch-dsl
Python Django
1 vote240 views1 answer
Change every value in a np array
Python
0 vote267 views1 answer
Https://stackoverflow.com/questions/55861077/hackerrank-lists-problem-standard-test-case-works-but-others-dont
Python
0 vote255 views1 answer
Free wifi connection disconnects frequently windows 10
Python