The LPA Dashboard has started to become very slow to load, and often leads to error in the service please try again errors. This is a big issue that will be addressed further on however there are small wins that can be made (I believe)
Currently timing all the different fetch functions made by the LPA dashboard, the fetchEntityIssueCounts seems to be very slow at over 8 seconds, just a query to Datasette Fetch Entity Issue Counts will show how slow it is.
This function has been moved to the performance db with this lookup New Datasette Query. This seems to be a lot faster and currently seems to work as expected with this change.
Furthermore, the fetch functions have now been parallelized and one fetch function removed that wasn't adding anything to the dashboard.
This branch https://github.com/digital-land/submit/tree/efficient-fetchEntityIssueCounts shows the work done.
The LPA Dashboard has started to become very slow to load, and often leads to error in the service please try again errors. This is a big issue that will be addressed further on however there are small wins that can be made (I believe)
Currently timing all the different fetch functions made by the LPA dashboard, the fetchEntityIssueCounts seems to be very slow at over 8 seconds, just a query to Datasette Fetch Entity Issue Counts will show how slow it is.
This function has been moved to the performance db with this lookup New Datasette Query. This seems to be a lot faster and currently seems to work as expected with this change.
Furthermore, the fetch functions have now been parallelized and one fetch function removed that wasn't adding anything to the dashboard.
This branch https://github.com/digital-land/submit/tree/efficient-fetchEntityIssueCounts shows the work done.