search

tonindexer / anton

Indexing for TON blockchain
https://anton.tools
Apache License 2.0
74 stars 16 forks source link

Slow performance when filtering latest account states by interface #29

Open iam047801 opened 9 months ago

iam047801 commented 9 months ago

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"