Issue Task Rejected

#90420Add index to fe_users table to improve backend list view performance with >100k rows

Robert Heinig 02/18/20, 15:31 updated 02/19/22, 15:11

Description

File in current master:
https://github.com/TYPO3/TYPO3.CMS/blob/master/typo3/sysext/frontend/ext_tables.sql

Index could be:

KEY backend_list_view_count (pid,deleted)

Index size with 150k rows is <3MB, so this index could be a default.

Could be backported to TYPO3 8 and 9.

Reviews 0

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