search

oasisprotocol / nexus

Official indexer for the Oasis Network.
Apache License 2.0
15 stars 4 forks source link

Querying events of busy contracts is slow / times out #722

Open lukaw3d opened 4 months ago

lukaw3d commented 4 months ago

0x08Fe02Da45720f754e6FCA338eC1286e860d2d2f contract was involved in 51972 transactions - many emitting ~6 events

https://nexus.prd.oasis.io/v1/sapphire/events?offset=0&limit=100&rel=0x08Fe02Da45720f754e6FCA338eC1286e860d2d2f

Responds after 47.29 s

https://nexus.prd.oasis.io/v1/sapphire/events?offset=0&limit=100&rel=0x08Fe02Da45720f754e6FCA338eC1286e860d2d2f&type=evm.log

A timeout occurred, Error code 524

https://nexus.prd.oasis.io/v1/sapphire/events?offset=20000&limit=100&rel=0x08Fe02Da45720f754e6FCA338eC1286e860d2d2f&type=evm.log

A timeout occurred, Error code 524

lukaw3d commented 3 weeks ago

https://testnet.nexus.oasis.io/v1/sapphire/events?offset=0&limit=10&rel=oasis1qzna6nq9kuktjmxx2s84z38eysqyts84jc9lgdg2&type=consensus_accounts.deposit

Error 524 after 1.7min

I used this to try to check if testnet faucet is working in https://github.com/lukaw3d/oasis-status-cronjobs/blob/b42f207d250eb86daf5576d753aa941f5c668270/.github/workflows/testnet-faucet-is-succeeding.yml#L21