Account search endpoint is very slow

Question

Account search endpoint is very slow

Opened this issue 4 years ago · 2 comments

http://api-01.us-east-1.testnet.symboldev.network:3000/accounts?pageSize=25&pageNumber=1&order=desc&orderBy=balance&mosaicId=2CF403E85507F39E

Answer 1 · 2021-02-26T15:51:37.000Z

api results in collscan

,"command":{"aggregate":"accounts","pipeline":[{"$unwind":"$account.mosaics"},{"$match":{"account.mosaics.id":3239218328380109726}},{"$sort":{"account.mosaics.amount":-1}},{"$skip":0},{"$limit":25}],"cursor":{},"lsid":{"id":{"$uuid":"fd8467db-7bfd-44be-a45e-c528f1990916"}},"$db":"catapult"},"planSummary":"COLLSCAN"

Answer 2 · 2021-03-09T14:28:11.000Z

Downgraded to P2 after internal discussion, it is working fine on the experimental mainnet network. this can be fixed post-launch