cancel
Showing results for 
Search instead for 
Did you mean: 

Cache API response for multiple parameters

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

JurusGomes
Member
0 REPLIES 0