Performance is important

I was on duty for the whole week last week. It was really hard. At the early stage of the launch, frontline operators were not familiar with the operation. More importantly, the problems caused by the immature software made me exhausted, fortunately, you can have a good rest.
This Monday is the busiest time in the morning, but unfortunately the bad thing happened. At around half past nine, the Internal Medicine Department called to say that the system was running very slowly. It would take 1-2 minutes for doctors to save a doctor's advice, this is not an exaggeration. I tried it myself and it took about one minute. So I immediately called the toll booth and asked about the speed. As a result, the other party said that I was trying to call us to say that the speed was very slow, the patient has been discharged to the stairway ....... In fact, this problem has occurred last week, and the client's running speed has been declining for a long time. As a result, I found the cause and started to do it in the database. ArticleAdd indexes and increase the temporary tablespace, but the effect is minimal.
Today, the company told me that they found the cause. They added debugging output to their data category and found that, the doctor may send hundreds of SQL Execution requests within a few minutes after receiving the doctor's advice. Then I followed myself ProgramIt is terrible to find that many SQL requests are repeated, and most of them are repeated. I chose a doctor's advice and 16 SQL statements appeared. Now I understand that, even if the server processing capability is strong, it cannot resist such a waste of SQL requests. The system is a two-tier structure of C/S, and there is no intermediate application server, so it cannot be buffered, the key to solving the problem is to establish some caching mechanisms in the client program to reduce frequent queries to the database. However, this work is complicated and risky. I am going to seek a doctor's site program as a pilot program.