carp
carp copied to clipboard
Remove unused columns from `find()` calls
For both TransactionOutput::find()
and StakeCredential::find()
, the generated SQL query includes too many fields in the select (notably, it includes a payload field which slows down the query)
I tried to filter the columns returned using sea-orm's .column()
call, but that seems to add extra entries to the SELECT field instead of filtering down.
Will need to find if there is either a way to only select the columns we're interested in or just replace these queries with a sqlx call instead.