Consider using indexes to improve database performance

[david-venhoff]

Motivation

According to the django documentation, adding indexes should be priority number one to improve performance. However, after doing a quick code search I noticed that we did not set up a single index for any model.

Proposed Solution

Analyze and benchmark existing slow queries and add indexes where appropriate

Alternatives

Do nothing. Though if we want to improve the performance of the cms, we should really investigate this with the highest priority

User Story

Design Requirements

Use explain to figure out if an index would be useful
Basic profiling can be done with the django debug toolbar