I wanted to share this new document that outlines some things that we do to ensure high performance when running SubQuery projects internally, you might also find it incredibly useful!
If you have any other ideas, recommendations for other indexers, or things that you have learned along the way - please share them in this forum post below and we might even add them to our own documentation!