Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Slow performance when filtering latest account states by interface #29

Open
iam047801 opened this issue Oct 11, 2023 · 0 comments
Open
Labels
bug Something isn't working

Comments

@iam047801
Copy link
Collaborator

iam047801 commented Oct 11, 2023

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"
@iam047801 iam047801 changed the title Filter latest account states by contract interface is working slowly Slow performance when filtering latest account states by interface Oct 11, 2023
@iam047801 iam047801 added the bug Something isn't working label Oct 11, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant