We had a usecase to display 10K+ Products on a webpage, initally tried with doing a query and fecthing from postregres DB which had a 8-10 Sec latency and which was causing a performance impact of the web app.
To overcome this we took the approach of using redis where the client would make a api call to get the data from redis where the latency was 800 - 1000 ms which is a huge boost in performance
