List of projects on "Projects" page can be slow to display.
- its not instantaneous compared to the number of projects displayed
- it can be noticeably long to display results when enabling more facets
WS api/components/search_projects (internal) is providing the content of these pages.
Looking at some traces in dev from "Projects" page, out of 265ms (see details as comments):
- 185ms is spent querying ES
- 58ms is spent retrieving user's favourites from DB (??!!)
- 13ms in other SQL requests
After some investigations, it appeared that:
- removal of "global()" aggregation did improve the performance but wasn't the only cause of slowness
- quick look at profiling seem to indicate Lucene requests are numerous and a bit costly