ntn0de's avatar

Need idea.

Hey Guys I have recently built an an web api. which will be used to fetch data to mobile. Its an ecommerce application. Is it good to use caching ? If yes, how would it affect the change in quantity of a "product" in products table if ordered. Help needed

0 likes
2 replies
fylzero's avatar

@ntn0de Caching is basically "scale protection" for things that don't really need to be updated immediately. If that sounds like what you need, then go for it.

Basically if I have users accessing the same data... and that data is called a lot and doesn't need to be to-the-second accurate. I'll decided how long it is acceptable for that data to be refreshed. Sometimes that is 5 minutes, sometimes an hour, sometimes a week. It depends on what is acceptable for that specific use case.

Forward thinking this is great if you know something will cause a bottleneck. In general, you can get a sense of where things slow down and optimize as you go along.

25 likes
ntn0de's avatar

Thanks . Can we cache only some tables or columns ?

Please or to participate in this conversation.