Improving response time for Geographically distributed caches using query result caching

Caching is an important technique to reduce network traffic and increase the performance of the applications. In distributed or client/server database environments caching can introduce the issue of inconsistency and latency. Traditional caching architecture is difficult to meet the needs of the users and business both, where faster responses are expected. So, to improve this technique we have proposed an architecture for a distributed network environment where a local cache interacts with a remotely located cache in case of any data miss and updates the local cache for faster responses. In a scenario where remote cache to misses the queried dataset the request to fetch the records is directed to the Primary data store, which will update both the local and remote caches with the desired data. This approach drastically reduces the response time for the user to fetch the same set of record next time, decreasing the latency time and increasing the overall performance of the infrastructure