Wednesday, June 19, 2024
1 change · saas-17.3
Enhancements to existing features
The accounting dashboard now loads outstanding payment information more efficiently. This can noticeably reduce waiting time when opening the dashboard, improving day-to-day usability for finance teams.
Original PR description
Allow the planner to use the index `account_payment_unmatched_idx` instead of a seq scan. Even if `account_payment` is not a huge table, we can still gain some time on the dashboard using the index. On a test database, the timing goes from 170ms to 1ms. The query represented 20% of the total time of the loading of the dashboard.