Add Indexes (db_index=True)

django django-models django-database
catherine picture catherine · Feb 9, 2013 · Viewed 43.5k times · Source

I'm reading a book about coding style in Django and one thing they discuss is db_index=True. Ever since I started using Django, I've never used this function because I'm not really sure what it does.

So my question is, when to consider adding indexes?

Answer

Burhan Khalid picture Burhan Khalid · Feb 9, 2013

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.

Related questions

Update only specific fields in a models.Model

I have a model class Survey(models.Model): created_by = models.ForeignKey(User) question = models.CharField(max_length=150) active = models.NullBooleanField() def __unicode__(self): return self.question and now I want to update only the active field. So I do …

Read More
How to count the number of rows in a database table in Django

I have database created by Django model, where status and id and username are the fields of the table Messages. I need to count the number of rows where status value= 0 for a particular username. This is my incomplete code: …

Read More
"Returning to that page might cause any action you took to be repeated" - Django

I have a form on my website, that creates an entry in database. So every time when I refresh a page I got this message first: The page that you're looking for used information that you entered. Returning to that …

Read More