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 (#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.
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information