Refactors the Hasura queries used in the sequencing server to be faster and the DB queries to not join on unnecessary tables.
Verification
Manually testing the queries gave a time increase from ~17s with the old Hasura queries to ~1s with the new queries.
The DB queries are negligibly faster (66ms vs 55ms). These timings came from running the queries against the Clipper dev venue that was having the issue.
Description
Refactors the Hasura queries used in the sequencing server to be faster and the DB queries to not join on unnecessary tables.
Verification
Manually testing the queries gave a time increase from ~17s with the old Hasura queries to ~1s with the new queries. The DB queries are negligibly faster (66ms vs 55ms). These timings came from running the queries against the Clipper dev venue that was having the issue.
Documentation
No docs need to be updated
Future work