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

1 vote258 views1 answer
How to change web browser in python
Python
0 vote240 views1 answer
Django rest framework multiple user registration
Python Django
0 vote274 views1 answer
Standard scaler vs min max scaler
Python
0 vote263 views1 answer
Interval time specification
Python
15 votes251 views4 answers
Find max value index in value count pandas
Python
2 votes260 views1 answer
Python calling dynamic function on object
Python
0 vote262 views1 answer
Remove toggle/pandaslux
Python
1 vote271 views1 answer
Change index function for class python
Python
0 vote293 views1 answer
Store content to file python
Python
2 votes286 views4 answers
Python web scraping
Python