Epic #88474: Page tree performance in 9.5
Page tree data fetching is using a huge amount of memory in PHP
Maintaining a website with over 100.000 pages I've noticed the page tree, which is claimed to be fast, becomes extremely slow on big TYPO3 instances. This is due to the fact the new page tree, in more detail the new page tree repository, is fetching all 100.000 pages and puts them in an array. With an average of 750 bytes per page this array consumes 75 Megabytes only. Three similar arrays are produced in the new page tree repository, each consuming approx the same amount of memory, so in total 225 Megabytes, which is way too much.