[pupdogg]

I would need to know a little more about those 1M requests before making any of your points valid. If 1M are solely reads, you can do real-time transient offload onto Redis without calling it cache and breaking your bank.

[dbmikus]

True. I would rephrase option 2 as "cache and/or replicate your query results somewhere".