Wednesday, June 19, 2024
1 change · saas-17.2
Resolved issues and error corrections
The accounting dashboard now uses information it already has to narrow down where it looks for missing sequence numbers. This greatly speeds up opening related accounting lists, reducing waits that could previously take many seconds.
Original PR description
From the dashboard, we already know in which sequence the gaps are. By filtering the moves based on that information, we can dramatically improve the performance by not querying the whole table. On a test server queries using this condition went from 10s to 5ms. When opening the list view from the dashboard, 2 queries are run for a total of 20s (`web_search_read` and `web_read_group`)