Fail to display HOME tab when repository contains 100 Million documents

In a 9.1-SNAPSHOT load testing environment, we have 100 Million File documents created with the bulk-importer (random title and data in dublincore)

In JSF UI, switching to the "HOME" tab fails after a while (some minutes, maybe 3-4). (a timeout in a query to the database?) => See the log.attached to this bug report

Installed plugins: nuxeo-jsf-ui, nuxeo-web-ui, and nuxeo-bulk-importer, nuweo-dam and nuxeo-drive
Using MongoDB and a standalone Elasticsearch

I assume the bug would be the same on 8.10 with the same load and configuration

See also NXP-21283