Loris icon indicating copy to clipboard operation
Loris copied to clipboard

[SQL] Faster loading of raisinbread test data

Open driusan opened this issue 2 months ago • 1 comments

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.

driusan avatar Oct 22 '25 16:10 driusan

Added Needs Work because the API tests are not running properly even though they say they're passing and I need to investigate why.

driusan avatar Oct 22 '25 19:10 driusan