Project

General

Profile

Actions

Task #88896

closed

Add index to slug field

Added by Forger Service over 4 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Link Handling, Site Handling & Routing
Target version:
-
Start date:
2019-08-02
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
10
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

`TYPO3\CMS\Core\Routing\PageRouter::getPagesFromDatabaseForCandidates` looks-up candidates for the page using the `slug` field (and also sorts by this value). This has some serious impact on the website performance on systems with lots of pages. In order to optimize this, an index should be set.

This issue was automatically created from https://github.com/TYPO3/TYPO3.CMS/pull/184


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #89846: Missing database indicesRejectedJonas Eberle2019-12-04

Actions
Actions #1

Updated by Gerrit Code Review over 4 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/c/Packages/TYPO3.CMS/+/61403

Actions #2

Updated by Josef Glatz over 4 years ago

  • Subject changed from [FEATURE] Add index to slug field to Add index to slug field
  • TYPO3 Version changed from 8 to 10
Actions #3

Updated by Gerrit Code Review over 4 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/c/Packages/TYPO3.CMS/+/61403

Actions #4

Updated by Riccardo De Contardi over 4 years ago

  • Category set to Link Handling, Site Handling & Routing
Actions #5

Updated by Gerrit Code Review over 4 years ago

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

Actions #6

Updated by Gerrit Code Review over 4 years ago

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

Actions #7

Updated by Gerrit Code Review over 4 years ago

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

Actions #8

Updated by Jonas Eberle over 4 years ago

  • Related to Bug #89846: Missing database indices added
Actions #9

Updated by Gerrit Code Review over 4 years ago

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

Actions #10

Updated by Gerrit Code Review over 4 years ago

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

Actions #11

Updated by Anonymous over 4 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #12

Updated by Benni Mack about 4 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF