[FINERACT-1114] Slow Query

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: Performance
• Labels: scalability
• Environment: Server configuration is 16 vCPU, 64GB RAM and 250GB SSD storage. ; Mifos setup has been done using AWS-AMI
• Flags: Patch, Important
• Assignee: Unassigned
• Reporter: Roshan Ratnaweera
• Created: 09/Aug/20 01:18
• Updated: 03/May/21 11:11

Description

 

1. Loan disbursement
2. viewing the net amount of teller (Teller cash management)
3. settle cash

When a user attempts to perform one of the above functions, a "select query" is activated to retrieve the net amount of his cash on hand. It checks for every transaction he made such as teller cash management, savings transactions, FD transactions and loan transactions.

This is the reason why the performance of the server is greatly reduced after using Mifos X for about two years. No matter how many server resources you increase, slowing down is unavoidable.

If we can implement a day end process of updating the summary of each teller's cash on hand to a separate table, it will be a solution for this. Then when you try to do one of the above tasks, instead of checking all the transactions, you can get the relevant teller's net amount very quickly by referring to that table.

herewith attached slow queries also.