[TASK] Add index to l10n_source field 34/62534/3
authorRiny van Tiggelen <info@online-gamer.nl>
Thu, 5 Dec 2019 07:47:51 +0000 (08:47 +0100)
committerTobi Kretschmann <tobi@tobishome.de>
Tue, 14 Jan 2020 07:47:30 +0000 (08:47 +0100)
The database field which is created based on TCA setting
translationSource, now automatically gets an index.
This improves the performace in (for example) the
migration from pages_language_overlay to pages.

Resolves: #89853
Releases: master, 9.5
Change-Id: I23ba8254158250249422b9fb0d20975372a11dbd
Reviewed-on: https://review.typo3.org/c/Packages/TYPO3.CMS/+/62534
Tested-by: TYPO3com <noreply@typo3.com>
Tested-by: Richard Haeser <richard@maxserv.com>
Tested-by: Oliver Bartsch <bo@cedev.de>
Tested-by: Jonas Eberle <flightvision@googlemail.com>
Tested-by: Jörg Bösche <typo3@joergboesche.de>
Tested-by: Steffen Frese <steffenf14@gmail.com>
Tested-by: Tobi Kretschmann <tobi@tobishome.de>
Reviewed-by: Guido Schmechel <guido.schmechel@brandung.de>
Reviewed-by: Oliver Bartsch <bo@cedev.de>
Reviewed-by: Jonas Eberle <flightvision@googlemail.com>
Reviewed-by: Jörg Bösche <typo3@joergboesche.de>
Reviewed-by: Andreas Fernandez <a.fernandez@scripting-base.de>
Reviewed-by: Steffen Frese <steffenf14@gmail.com>
Reviewed-by: Tobi Kretschmann <tobi@tobishome.de>
typo3/sysext/core/Classes/Database/Schema/DefaultTcaSchema.php

index fe3ce1a..a4b3cab 100644 (file)
@@ -314,6 +314,7 @@ class DefaultTcaSchema
                         'unsigned' => true,
                     ]
                 );
+                $tables[$tablePosition]->addIndex([$tableDefinition['ctrl']['translationSource']], 'translation_source');
             }
 
             // l10n_state column