I want to share my experience on a distributed system and the challenge that we faced as a team. We have built a web-application that is managed centrally. Installed and runs off from a central server - works fine or does what is expected in terms of functionality. However, we are being challenged on performance issues. We are getting network latency - before our new web-application gets deployed, there is a legacy standalone or desktop system that runs on multiple branches and states as a distributed system. The legacy does not have a performance issue because the application and database are on the same local network.
However, for the centralized application which is the new one, we have identified that some branches are slow, and we also have identified mainly because of the network issue but we have to overcome the problem at the same time. We are getting slow response times for some reports and/or requests.
What options do we have to give as a solution(s) for these poor performance sufferings?
What I have tried:
caching using redis, query optimization, and reduced chatty requests and used dapper