Loris
Loris copied to clipboard
[SQL] Faster loading of raisinbread test data
This speeds up make testdata (and the GitHub Actions tests in general) faster by converting the format of loading from one INSERT statement per row to a bulk LOAD DATA LOCAL INFILE statement loading the data from a tsv.
The tsv is also more readable than the insert statements and smaller on the filesystem.
On my laptop, this took the load time from approximately 13.5 minutes to 30 seconds.
Added Needs Work because the API tests are not running properly even though they say they're passing and I need to investigate why.