[BUGFIX] Add index to pid column in sys_file_metadata 72/57372/3
authorFrédéric Lebel <flebel@opval.com>
Tue, 26 Jun 2018 02:59:14 +0000 (02:59 +0000)
committerChristian Kuhn <lolli@schwarzbu.ch>
Tue, 26 Jun 2018 20:00:55 +0000 (22:00 +0200)
This improves the performance of the page tree in workspaces.

Resolves: #85387
Releases: 8.7
Change-Id: I55609d3af95c8352216f1958ea233ed0ef5802f5
Reviewed-on: https://review.typo3.org/57372
Reviewed-by: Tymoteusz Motylewski <t.motylewski@gmail.com>
Tested-by: Tymoteusz Motylewski <t.motylewski@gmail.com>
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Stephan Großberndt <stephan.grossberndt@typo3.org>
Reviewed-by: Oliver Klee <typo3-coding@oliverklee.de>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Christian Kuhn <lolli@schwarzbu.ch>
typo3/sysext/core/ext_tables.sql

index 0b2b262..8ddf2b7 100644 (file)
@@ -333,6 +333,7 @@ CREATE TABLE sys_file_metadata (
        alternative text,
 
        PRIMARY KEY (uid),
+       KEY pid (pid),
        KEY file (file),
        KEY t3ver_oid (t3ver_oid,t3ver_wsid),
        KEY fal_filelist (l10n_parent,sys_language_uid)