View Releases (multiple releases) page is slow to load when large amounts of build information is present

[paulegradie]

The View Releases page makes API requests that return unnecessary data leading to slow page load times.

The Need

The View Releases page makes API requests that return unnecessary data. Limiting these payload sizes could speed up page load times.

Solution

A tactical fix for this page that mitigates a known issue with SqlClient where asychronous (i.e. sequential access) calls to SqlServer become very slow when returning rows that hold a large amount of text data. The fix is to invoke sqlClient synchronously.

[octoreleasebot]

Release Note: Improved View Releases page load time

[Octobob]

🎉 The fix for this issue has been released in:

Release stream	Release
2023.2	2023.2.10466
2023.3+	all releases