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 vote321 views1 answer
Django auto complete light styling
Python Django
0 vote267 views1 answer
How to resize image with pillow in django
Python Django
0 vote274 views1 answer
Aes in django
Python Django
0 vote276 views1 answer
Django send_mail not working in testcase
Python Django
1 vote287 views3 answers
Accessing data on django sessionstore
Python Django
1 vote304 views1 answer
Django filter after annotate
Python Django
0 vote295 views1 answer
Django Signup view
Python Django
1 vote297 views1 answer
Django filter by category
Python Django
1 vote328 views1 answer
How to create staff account in django
Python Django
1 vote304 views1 answer
Managin media django
Python Django