Issue Bug Closed

#91728Very slow tree loading if you have multiple workspaces TYPO3 v10

Danilo Caccialanza 06/30/20, 10:03 updated 07/28/20, 15:36

Description

Context:

  • Platform with 18000+ page tree
  • 8 workspaces (each workspace have ca. 2250 pages)
  • Our “Advanced Editors user” have access to 4 workspace

Problem:

Loading page tree is very slow (more. 40 second) when advanced editor access in LIVE and DRAFT WORKSPACES.

Using firebug I spotted the bottleneck in the call:
  • /typo3/index.php?route=/ajax/page/tree/fetchData&token=101678758c95c2d29a02a21b5f123c74503900ee

In TYPO3 v8 we have fix all adding database indexes, bat in v10 same indexes do not works.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.