[BUGFIX] Add missing SQL index for EM repository update 25/52725/2
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 14:47:58 +0000 (16:47 +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
Reviewed-on: https://review.typo3.org/52725
Reviewed-by: Jan Helke <typo3@helke.de>
Tested-by: Jan Helke <typo3@helke.de>
Tested-by: TYPO3com <no-reply@typo3.com>
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)
 );