[Bug] All Websites report slower in Matomo 5 than Matomo 3 when displaying date ranges

[atom-box]

What happened?

The All Websites report:

1. loads super fast for year, month, week :grinning:
2. loads ~never (many minutes later but usually times out; 504 Gateway error) for 5 days Date Range on 10,000 sites :disappointed:
3. loads in 20 seconds for 5 days Date Range on 900 sites :expressionless:

This might be a regression, because, the older Matomo versions loaded this pretty fast according to the user and also @mattab . The user says that moving from Matomo 3 to Matomo 5 caused the above problem.

What should happen?

Case 2, above, should load in a practicable amount of time: less than a minute, for 10,000 websites, like it used to.

How can this be reproduced?

You will need a Matomo instance with 9000 measurables. Open the All Websites page; it will timeout before it finishes opening in the browser. In the private notes of this ticket I will add some screenshots from the user.

Matomo version

5.1.0

PHP version

No response

Server operating system

Linux

What browsers are you seeing the problem on?

Firefox, Chrome

Computer operating system

No response

Relevant log output

No response

Validations

• [X] Read our Contributing Guidelines.
• [X] Follow our Security Policy.
• [X] Check that there isn't already an issue that reports the same bug to avoid creating duplicates.
• [X] The provided steps to reproduce is a minimal reproducible of the Bug.

[atom-box]

This is superseded by https://innocraft.atlassian.net/browse/DEV-16541 Therefore I am closing this ticket now.