Speed up slow database queries #233
Description
We have some slow queries, and some others that are getting slower:
- radio dashboard (Speed up the radio dashboard #154, Radio dashboard is slow #157)
- schedule home page
We need to make sure we have the necessary optimizations to upscale the DB capacity - be it a missing index, a suboptimal query or a slow data type, we should figure out the bottlenecks and eliminate them.
Task also includes:
- going through all raw queries in the code and replacing them with ORM-powered queries, wherever possible
- checking the database structure for potential optimizations and bottlenecks - any complex operations should be, however, tracked in separate issues