Performance: Batched / pipelined indexer writes and bulk upserts

[joelpeace48-cell]

Context

If the indexer writes one row per event, high-throughput ledgers will bottleneck on per-row writes.

Scope

• Batch events into bulk upserts within a transaction; tune batch size.
• Pipeline RPC fetch and DB write; measure events/sec.

Acceptance criteria

• Indexer sustains target events/sec via batched writes without falling behind.

Verification

• Replay a high-event range and assert throughput + no lag growth.

[jesutobaadedejidev]

I would like to work on this. Do assign it to me.

[gloskull]

Hello, I have 4 years of experience delivering solutions for projects like this, covering backend, frontend, and smart contract development. After carefully reviewing your requirements, I have a clear understanding of the task and am confident in my ability to deliver a clean, efficient, and thoroughly tested solution on time. I prioritize code quality, maintainability, and industry best practices throughout the development process. My PR will be submitted in under 10hours.