[TASK] Add missing index on table sys_file_reference 12/51512/4
authorThomas Hohn <thomas@hohn.dk>
Thu, 2 Feb 2017 15:43:15 +0000 (16:43 +0100)
committerChristian Kuhn <lolli@schwarzbu.ch>
Thu, 23 Feb 2017 15:40:25 +0000 (16:40 +0100)
During copying of pagetrees various sql statments
are executed. One on sys_file_reference has a bad
performance and can benefit from an index.

Fixes: #79604
Releases: master

Change-Id: I2caa83db6259ad6baad75427b5040a11ece768ba
Reviewed-on: https://review.typo3.org/51512
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Georg Ringer <georg.ringer@gmail.com>
Tested-by: Georg Ringer <georg.ringer@gmail.com>
Reviewed-by: Joerg Boesche <typo3@joergboesche.de>
Tested-by: Joerg Boesche <typo3@joergboesche.de>
Reviewed-by: Stephan GroƟberndt <stephan@grossberndt.de>
Reviewed-by: Christer V <cvi@systime.dk>
Reviewed-by: Claus Due <claus@phpmind.net>
Tested-by: Claus Due <claus@phpmind.net>
Reviewed-by: Morten Pless <mpl@systime.dk>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Christian Kuhn <lolli@schwarzbu.ch>
typo3/sysext/core/ext_tables.sql

index 60f77c3..2c902b5 100644 (file)
@@ -420,7 +420,8 @@ CREATE TABLE sys_file_reference (
        KEY tablenames_fieldname (tablenames(32),fieldname(12)),
        KEY deleted (deleted),
        KEY uid_local (uid_local),
-       KEY uid_foreign (uid_foreign)
+       KEY uid_foreign (uid_foreign),
+       KEY combined_1 (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted)
 );