Reduce database size and variance of query response times
The ExoneraTor database has grown to 262 GB, and sometimes queries can run for up to a minute or even longer (legacy/trac#17488 (moved)). Both issues are known for years, and they're getting even worse over time as new data gets added.
Sebastian and I discussed possible mitigations over two years ago, and we came up with an improved database schema. Well, Sebastian did the bulk of the work there.
I picked up this work, rebased it to current master, made some fixes, and ran tests on a local database copy. Let's try to merge and deploy this in the next couple of weeks before the code gets old again like last time.