Hi All,

We are facing performance issues while running the batch payroll process, It takes 3.5 sec to generate a payslip for a single employee. As the number of employees is high we should reduce that to milliseconds. Any suggestion or insight will be much appreciated.

The following describes the backend process of the Batch payroll process,

Batch Payroll Process -> Attendance Data Check -> Salary Rule check in salary structure -> Salary Calculation based on Attendance and Salary Rule -> Payslip Generation.  

Some key information

• There are 13k employees in the database
  
• There are 60+ salary rules per salary structure
• There are 04 salary structures

 Looking forward to any quick help.