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 vote316 views1 answer
Autofield in django
Python
0 vote298 views1 answer
Global /tmp/pip-req-build-civioau0/opencv/modules/videoio/src/cap_v4l.cpp (587) autosetup_capture_mode_v4l2 VIDEOIO(V4L2:/dev/video0): device is busy
Python
4 votes304 views2 answers
How to convert a am pm string to 24 hrs time python
Python
0 vote366 views1 answer
Django time cualtulate
Python Django
0 vote304 views1 answer
How does tkinter iconify() function work in python
Python
3 votes284 views2 answers
Plot bounds python
Python
0 vote300 views1 answer
Python - count number of occurence in a column
Python
0 vote296 views1 answer
Timestamp' object has no attribute 'isnull
Python
1 vote246 views1 answer
Python if boolean
Python
7 votes317 views5 answers
.format python 3
Python