To mitigate currently SubSquid/Rubick downtimes (indexer) we had to disable gains and holdings on the user profile to have a much more reliable service.
Steps to return this back would be
introduce pagination on the query, not on the client-side
introduce caching, within 1-hour time frame best
test it wisely once on deploy preview with grafana dashboard if it collapses indexer on the background (@yangwao @vikiival has it)
yangwao
commented
2 years ago
To mitigate currently SubSquid/Rubick downtimes (indexer) we had to disable gains and holdings on the user profile to have a much more reliable service.
Steps to return this back would be
Ref
Originally posted by @yangwao in https://github.com/kodadot/nft-gallery/issues/3425#issuecomment-1181861033