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

• No trending collection on focus on search bar nft-gallery#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