Sorting by most supply is too slow

[newraina]

What happened?

On RMRK2, after selecting sort by most supply, I haven't had any success in getting results, I usually get two kinds of errors:

1. The query failed after 1min, status=504
2. The query ends in the middle, status=200, but the return is error: canceling statement due to statement timeout

Not sure if this can be improved on the index side? @vikiival

On other networks, this sorting option is also relatively slow, but I can still get results.

Please reproduce in steps

1. https://canary.kodadot.xyz/ksm/explore/collectibles?sort=supply_DESC
2. waiting results
3. Most of time you won't be able to get the results

Expected Behavior

You can see the sorted results normally.

What browsers are you seeing the problem on?

No response

At which address did you encounter bug?

No response

Are you logged in?

None

Which wallet you are using?

No response

At which chain did you encounter bug?

No response

Screenshots

Relevant log output

No response

Payment link for reward

Payout

Code of Conduct

• I agree to follow this project's Code of Conduct

[yangwao]

I think this would need make resolver on indexers
cc @vikiival
maybe related

• feat: Add volume sort to ExploreSort #5699

[vikiival]

I think this would need make resolver on indexers

Nope

• Add indexes to sort fields loligo#47

On RMRK2, after selecting sort by most supply, I haven't had any success in getting results

Yup It has like a milion items so you would feel it

[roiLeo]

• ref Sorting by Most supply for rmrk2  #5086