[BUGFIX] Add SQL Index to Processed Files DB table 28/26628/5
authorIngo Schmitt <is@marketing-factory.de>
Fri, 3 Jan 2014 16:03:49 +0000 (17:03 +0100)
committerBenjamin Mack <benni@typo3.org>
Tue, 14 Jan 2014 12:34:32 +0000 (13:34 +0100)
Added index to original,task_type,configurationsha1
this improves performance for non-cached pages and
backend calls

Resolves: #54729
Releases: 6.2
Change-Id: I2ecfe62c64b89078da5c04ee708ea3c343d4fc9a
Reviewed-on: https://review.typo3.org/26628
Reviewed-by: Oliver Klee
Reviewed-by: Steffen Ritter
Tested-by: Steffen Ritter
Reviewed-by: Benjamin Mack
Tested-by: Benjamin Mack
typo3/sysext/core/ext_tables.sql

index f150187..615d647 100644 (file)
@@ -377,7 +377,8 @@ CREATE TABLE sys_file_processedfile (
        width int(11) DEFAULT '0',
        height int(11) DEFAULT '0',
 
-       PRIMARY KEY (uid)
+       PRIMARY KEY (uid),
+       KEY combined_1 (original,task_type,configurationsha1)
 );
 
 #