Skip to content

Slow performance when filtering latest account states by interface #29

@iam047801

Description

@iam047801

Descending order:

945ms  |  GET "/api/v0/accounts?interface=dns_nft_item&order=desc&limit=20&latest=true"
3.73s  |  GET "/api/v0/accounts?interface=jetton_minter&order=desc&limit=20&latest=true"
4.79s  |  GET "/api/v0/accounts?interface=nft_collection&order=desc&limit=20&latest=true"
10.7s  |  GET "/api/v0/accounts?interface=wallet_v1r3&order=desc&limit=20&latest=true"

Ascending order:

4.07s  |  GET "/api/v0/accounts?interface=jetton_minter&order=asc&limit=20&latest=true"
10.5s  |  GET "/api/v0/accounts?interface=jetton_wallet&order=asc&limit=20&latest=true"
10.6s  |  GET "/api/v0/accounts?interface=nft_collection&order=asc&limit=20&latest=true"
10.8s  |  GET "/api/v0/accounts?interface=nft_editable&order=asc&limit=20&latest=true"
12.2s  |  GET "/api/v0/accounts?interface=nft_item&order=asc&limit=20&latest=true"

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions