Web Services - It's Not As Easy After All
As I need to deal with servers' services for my company, I have to think of solution that's not only able to cope with the expansion of the service, but also able to handle most unwanted scenario gracefully that would not cost the services to break down just because of one failure. On top of that, I do have to find out solution as well on how to improve the throughput of the service. 1. Database Related Issue Lately I've been trying to look into the reason behind the reason why one of our services have become so slow in producing and output. So in order to do so, I tried to capture some information and display them in the log file. This is not really efficient at all because if possible, I'd prefer the log file to be able to be exported into e.g. an Excel worksheet so that I could use the data to create some statistic. The captured information shows that one of the reason for such a delay (over 10 seconds to process 1 request, which is not very acceptable at all) was