Bug #59824: Better index for determineSiteRoot - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #59824

closed

Better index for determineSiteRoot

Added by Stefan Froemken almost 10 years ago. Updated over 5 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Stefan Froemken

Category:

Database API (Doctrine DBAL)

Target version:

next-patchlevel

Start date:

2014-06-23

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

6.2

PHP Version:

5.4

Tags:

Complexity:

easy

Is Regression:

Sprint Focus:

Description

Hello Core-Team,

updating the index determineSiteRoot is a little bit faster:

|       13 | 0.00025900 | SELECT uid FROM pages WHERE deleted=0 AND hidden=0 AND is_siteroot=1 LIMIT 1
|       14 | 0.00022800 | SELECT uid FROM pages WHERE deleted=0 AND hidden=0 AND is_siteroot=1 LIMIT 1

Stefan

Related issues 2 (0 open — 2 closed)

Actions

Copy link

Updated by Gerrit Code Review almost 10 years ago

Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/31082

Actions

Copy link

Updated by Gerrit Code Review almost 10 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/31082

Actions

Copy link

Updated by Gerrit Code Review over 9 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/31082

Actions

Copy link

Updated by Gerrit Code Review over 9 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/31082

Actions

Copy link