sifive / wake

The SiFive wake build tool
Other
86 stars 28 forks source link

rsc: Add blob_id indexes for fks #1624

Closed V-FEXrt closed 1 month ago

V-FEXrt commented 1 month ago

Blob eviction queries were running unacceptably slow. This is because the FK checker had to linear search over the very large output_file table to ensure a deleted job wasn't reference. Adding an index converts the linear search into a much faster index lookup