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 vote258 views1 answer
Django test postgres extensions intarray
Python Django
1 vote239 views1 answer
Use django taggit in template
Python Django
6 votes268 views4 answers
Media django
Python Django
1 vote253 views1 answer
Correr servidor django
Python Django
17 votes242 views6 answers
Django model
Python Django
0 vote228 views1 answer
How to create decorator function in django
Python Django
0 vote263 views1 answer
Setting up a django prostgress project
Python Django
2 votes224 views1 answer
Django register models
Python Django
0 vote259 views1 answer
Instal django impoer expor
Python Django
1 vote243 views1 answer
Django filter by category
Python Django