Report execution taking longer to complete in front end
Hello,
We are experiencing a performance issue with a custom report called the Trip Settlement Report, which is used to track the balance for settling payments on invoices.
The backend query execution time is approximately 0.019 seconds (as shown in the attached screenshots). However, on the frontend, the report used to complete within 10 seconds up until March, but now it is taking approximately 4-5 minutes to finish.
We have already developed and deployed a new template for the report, but the performance issue persists.
Could anyone kindly suggest any potential causes or provide recommendations on areas we should investigate to resolve this issue?