Spent 3 months building a Solana indexer and I'm still missing slots. What am I doing wrong?

The author spent 3 months building a Solana indexer but is still missing slots and struggling with scalability, leading to increased AWS bills. They are considering abandoning their own infrastructure and paying a data provider instead. The author is seeking advice from others who have run production Solana indexers.