Backfilling new schema takes long time with 100% cache rate

[Ashar2shahid]

Version

16.1

Current behavior

I am hosting my ponder app on railway with yarn start --schema $RAILWAY_DEPLOYMENT_ID, if I make any change to the contracts backfilling takes super long time even with 100% cache rate, I suspect I am doing something wrong for this to be the case

Expected behavior

should take less than 1 hour

Steps to reproduce

No response

Link to repository

No response

Anything else?

No response

[kevzzsk]

This happened to me as well. I believe in my case it was due to having heavy I/O operations in the indexing fns which stalls the indexers. I had a https fetch that delays the indexer, took that out and the indexing fly by so fast.

[kyscott18]

This is most likely because of unoptimized user land code, but I realize we don't have very good documentation for diagnosing and improving performance. This blog post does contain a lot of relevant information https://ponder.sh/blog/performance