Space-level Insights: Creating report fails when large number of projects/channels

[MJRichardson]

Severity

This prevents large customers from using space-level insights. This is a small number of customers, but the feature becomes unusable for them. It's an enterprise-tier feature.

Version

2023.2

Latest Version

I could reproduce the problem in the latest build

What happened?

Navigate to Insights (space-level). Attempt to create a report. The page hangs and then errors.

The network analysis in the browser dev tools show the /projects/all and /channels/all` calls as the culprits.

/projects/all took >3 minutes to return, while /channels/all failed after 10 minutes.

Reproduction

You can use Armada to create an instance with a large database. This was reproduced on an instance containing 10k projects and 26k channels.

Then navigate to Insights (top level nav). Then create a new report. The page load fails with an error.

Error and Stacktrace

No response

More Information

It seems the most immediate issue is loading all channels in ReportSettings.tsx.

Workaround

No response