Sorting and improved loading time for diagrams listing page
The diagrams index page is one of the most frequently used pages but has not received much attention since its inception. As teams are now creating even more diagrams, it is becoming increasingly challenging to browse and locate the desired diagram. The slow page load speed exacerbates this issue.
This week, we have added sorting options to address this. Diagrams can now be sorted by their creation date, updated date (the default), or alphabetically. Moreover, we have significantly improved the page load speed. We identified and resolved two main bottlenecks that were causing this slowness:
Presigned urls for the diagram images were loaded sequentially, and these were performed in sync with the main diagram listing query.
We had a N+1 query issue that had snuck into the main query
We were needlessly loading the entire diagram schema for each diagram
Overall, users should notice a considerable improvement in the page's performance with this update.