Account search endpoint is very slow

[OlegMakarenko]

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

[gimre-xymcity]

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"

[rg911]

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