Task #88896

Add index to slug field

Added by Forger Service 3 months ago. Updated about 2 months ago.

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

0%

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

History

#1 Updated by Gerrit Code Review 3 months 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

#2 Updated by Josef Glatz 3 months ago

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

#3 Updated by Gerrit Code Review 3 months 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

#4 Updated by Riccardo De Contardi about 2 months ago

  • Category set to Link Handling, Site Handling & Routing

Also available in: Atom PDF