[BUGFIX] Add missing SQL index for EM repository update 43/52743/2
authorClaus Due <claus@namelesscoder.net>
Mon, 1 May 2017 15:29:51 +0000 (17:29 +0200)
committerBenni Mack <benni@typo3.org>
Thu, 11 May 2017 09:34:18 +0000 (11:34 +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.

Resolves: #81097
Releases: 7.6, 8.7, master
Change-Id: I73bd78a7d923a1e49594374b0dd8fee270fa30a3
Reviewed-on: https://review.typo3.org/52743
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Oliver Klee <typo3-coding@oliverklee.de>
Reviewed-by: Claus Due <claus@phpmind.net>
Reviewed-by: Andreas Fernandez <typo3@scripting-base.de>
Reviewed-by: Benni Mack <benni@typo3.org>
Tested-by: Benni Mack <benni@typo3.org>
typo3/sysext/extensionmanager/ext_tables.sql

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)
 );