[BUGFIX] Add missing SQL index for EM repository update 70/52670/3
authorClaus Due <claus@namelesscoder.net>
Mon, 1 May 2017 15:29:51 +0000 (17:29 +0200)
committerJan Helke <typo3@helke.de>
Fri, 5 May 2017 15:52:22 +0000 (17:52 +0200)
Due to the large number of extensions, the query that
checks if an extension exists needs an index that
covers all of the columns used for joining/clauses.

Change-Id: I73bd78a7d923a1e49594374b0dd8fee270fa30a3
Releases: 8.7, master
Resolves: #81097
Reviewed-on: https://review.typo3.org/52670
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Christer V <cvi@systime.dk>
Reviewed-by: Andreas Fernandez <typo3@scripting-base.de>
Tested-by: Andreas Fernandez <typo3@scripting-base.de>
Reviewed-by: Michael Oehlhof <typo3@oehlhof.de>
Reviewed-by: Oliver Klee <typo3-coding@oliverklee.de>
Reviewed-by: Jan Helke <typo3@helke.de>
Tested-by: Jan Helke <typo3@helke.de>

index fcaaf4a..7890ae7 100644 (file)
@@ -42,7 +42,7 @@ CREATE TABLE tx_extensionmanager_domain_model_extension (
   lastreviewedversion int(3) NOT NULL default '0',
   PRIMARY KEY (uid),
   KEY index_extrepo (extension_key,repository),
-  KEY index_versionrepo (integer_version,repository),
+  KEY index_versionrepo (integer_version,repository,extension_key),
   KEY index_currentversions (current_version,review_state),
   UNIQUE versionextrepo (extension_key,version,repository)