Bootstrap performance improvement

[jrwbabylonlab]

Our indexer is currently quite slow when bootstrapping from block 0.

In the recent testnet, it took approximately two days to fully sync, even though the testnet has only been running for half a month.

Scope of This Ticket:

The goal is to improve the bootstrap process, as we are currently syncing events one by one. We should explore ways to parallelize this process using multiple goroutines.

Possible Approach:

One potential optimization is grouping events by stakingTxHash when processing blocks. This way, we can ensure that events with the same transaction hash are processed sequentially while allowing independent transactions to be processed concurrently.

Let’s investigate if this approach (or a similar strategy) can significantly reduce the indexing time.