Reducing your database load by caching your query
Some applications might have some extensive query which might take several seconds to response, some people said a few seconds isn’t a big problem. Now, let say you one heavy query which will take 2s , remember this that 2s is when your server in low load, when your server got few hundred hits to that query, that normal 2s is no longer 2s, it will be added up. If this continue, your server will be dead.First thing people will think about caching, using ngnix (for example), but remember that, ngnix cache is based on the url , this is good for static content. ModernRead More →