Project

General

Profile

Actions
Copy link

Bug #59824

closed

Better index for determineSiteRoot

Added by Stefan Froemken over 10 years ago. Updated about 6 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:
No
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)

Related to TYPO3 Core - Bug #59809: Create better indexes for EMClosedStefan Froemken2014-06-23

Actions
Related to TYPO3 Core - Bug #55180: Increase Determination of siteroot pageClosedIngo Schmitt2014-01-20

Actions
Actions
Copy link

Also available in: Atom PDF