Random 500 Errors

[barrett-ruth]

DigitalOcean exhibits high CPU usage.

Steps to address:

1. More CPUs! (just kidding, but kind of - need a safeguard anyway. One CPU for our entire application is not ideal. Luckily, deprecating elasticsearch perfectly covers the costs here).
2. No more DigitalOcean (long term)
3. Debugging the queries to see which take the most time (excessive fields being queried?)

[wkaisertexas]

I took a small crack at this last week and some of the api calls were just atrocious.

For example, the allstats flag on the courses route used distinct for everything which lead to a ~1 second mean response time when most other queries ran in <1 ms given the small size of our database.

[wkaisertexas]

Why are we migrating away from digital ocean?