Cache does not work with RMRK2

[vikiival]

The point why cache currently does not work is that queries does not run properly (take around 7s+ to execute).

How to fix:

• [ ] run indexer for few days
• [ ] open DataGrip and connect to DB
• [ ] run the query in cache.ts called series
• [ ] optimize run time while returning same data

$$ included

Blocker for

• https://github.com/kodadot/nft-gallery/issues/5486

[roiLeo]

Hello, have you heard of https://stellate.co/docs, can it be integrated with squid?

[vikiival]

Hello, Yes we heard about stellate, however the issue is that the cache query is badly written, therefore it takes 7s to process