Hi! I have a situation where I need to query a table that increases it's size by 200k records every 3 months. There is an API that runs the stored procedure using Dapper. There are 10 to 15 different parameters that affect the query results.
What would be a good way to cache the API response for the parameters combination? What are some good caching mechanisms that could be useful in this situation? Every different parameters combination should run the query again and cache it for certain period of time.
Thanks
