perf: speed up assignment creation

- use a database view of the sabretooth recording table
to speed up location of participants