[TASK] Add sys_domain index matching getDomainStartPage query 17/52017/2
authorClaus Due <claus@namelesscoder.net>
Sun, 12 Mar 2017 18:45:24 +0000 (19:45 +0100)
committerGeorg Ringer <georg.ringer@gmail.com>
Mon, 13 Mar 2017 07:40:52 +0000 (08:40 +0100)
The added index optimises the query that executes on every
single page load both cached and uncached.

Change-Id: I67dd28d08322442fcacdc5101e0063d072b25ae2
Resolves: #80247
Releases: master
Reviewed-on: https://review.typo3.org/52017
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Thomas Hohn <thomas@hohn.dk>
Tested-by: Thomas Hohn <thomas@hohn.dk>
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Reviewed-by: Georg Ringer <georg.ringer@gmail.com>
Tested-by: Georg Ringer <georg.ringer@gmail.com>
typo3/sysext/frontend/ext_tables.sql

index 594207c..36cfa88 100644 (file)
@@ -169,7 +169,8 @@ CREATE TABLE sys_domain (
 
        PRIMARY KEY (uid),
        KEY parent (pid),
-       KEY getSysDomain (redirectTo,hidden)
+       KEY getSysDomain (redirectTo,hidden),
+       KEY getDomainStartPage (pid,hidden,domainName)
 );
 
 #