Optimise the worst 5 SQL queries from production

Description

We should look at the cumulative times for our SQL queries across some of our production boxes (over say, a week), and optimise where we can. For instance, extra indexes, more caching. I can see that HApplicationConfiguration gets hit a lot, for instance, and should benefit from caching because it changes rarely.

Assignee

Unassigned

Reporter

Sean Flanigan

Labels

None

Tested Version/s

None

Components

Priority

unspecified
Configure