The ProgramRun database table is currently the largest table in the database, taking up approximately 25GB of space. This table stores a snapshot of the solution, library, and test code as it was during the last execution of the graded and user tests.

We can reduce the size of the ProgramRun-data table by switching to storing only the hashes of the solution, library, and test code. This would reduce the size of the table to under 2GB. We can still derive the code as it was during a program run by comparing the hashes with the ones from revision history.

Benefits:

• Reducing the size of the ProgramRun-data table would free up space in the database (and speed up backup)
• Storing only the hashes of the code would speed up the process of persisting program-run updates to the database, which happens on each poll for program execution updates

Submitted by Elmer van Chastelet on 18 July 2023 at 14:22