Project

General

Profile

Actions

Task #84084

closed

No SQL index declared including colPos

Added by Claus Due about 6 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Performance
Target version:
-
Start date:
2018-02-28
Due date:
% Done:

0%

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

Description

Much to my surprise, not least because I haven't noticed this through the nearly 10 years I worked with TYPO3, but:

There is no SQL key which matches the default query that results from selecting `tt_content` with a particular colPos value.

Adding this index would be excessively easy. Patch is coming right up. Can be backported as far back as you wish.

Actions #1

Updated by Gerrit Code Review about 6 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/55941

Actions #2

Updated by Gerrit Code Review about 6 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/55941

Actions #3

Updated by Gerrit Code Review about 6 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/55941

Actions #4

Updated by Susanne Moog about 5 years ago

Patch has been abandoned, open questions (see review) need answers.

Actions #5

Updated by Susanne Moog about 5 years ago

  • Status changed from Under Review to Needs Feedback
Actions #6

Updated by Christian Eßl over 4 years ago

  • Category set to Performance
Actions #7

Updated by Susanne Moog about 4 years ago

  • Status changed from Needs Feedback to Closed

Task that was never completed, got no feedback since a long time, has open questions and from the discussion in the review should not be done. Closing the issue now.

Actions

Also available in: Atom PDF