I am using the 17.07.01 version. Server configuration is 16 vCPU, 64GB RAM and SSD storage. There are 37.2Min records in the “acc_gl_journal_entry” table and maximum concurrent user count is 30 (from 15 branches)
viewing the net amount of teller (Teller cash management)
Above two tasks are taking a long time to process. When a bunch of these two tasks are running, server CPU are 100% utilized by relevant sql select queries.
When the server is not going to normal status, I am killing frozen select queries. Then suddenly the server is going back to normal.
I have noticed that these delayed two queries, read all transactions of relevant users. I think, that is why it takes a long time to process. Are any solutions available for this ?
Mr. Bharath has suggested to archive the relevant tables. Please help me urgently to prevent this situation.