'How to scale the application and should we introduce caching?
In my company, we've built a dashboard. In that dashboard, we display some values which are computed by fetching all the records from a table and processing them. Right now, we have around 98,126 records in the table. But as we grow, these records will increase, and the frontend is already kind of getting slow because the processing of documents is getting slower day by day. So I've two questions regarding these.
How should we scale this? I mean we can change the queries to hit the database with some condition and bring in lesser documents in backend.
What kind of caching should we introduce here. Is it good to go with frontend caching such as CloudFront or backend caching like Redis caching?
We're using React in frontend, NodeJS & Express & Postgres & sequilize in backend.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|