Project

General

Profile

Actions

Task #54726

closed

Epic #55070: Workpackages

Epic #54260: WP: FAL Missing Issues / Features / API

Story #54266: As an User I want FAL to be performant

Task #51094: SQL-Optimize the FAL

sys_file_reference.fieldname optimize columns

Added by Ingo Schmitt over 10 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Performance
Target version:
Start date:
2014-01-03
Due date:
% Done:

100%

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

Description

MySQL up to 5.5 allows at maximum 64 characters for tablenames and fieldnames [1], thus no other DBAL implementation should use more than 64 characters.

This leads set the maximum size of the fields tablenames and fieldname to 64 chars.
The field sys_file_reference.fieldname should be varchar or char, not TINYTEXT.
since only fieldnames from the database are stored varchar(64) should be enough.

[1] http://dev.mysql.com/doc/refman/5.5/en/identifiers.html


Related issues 1 (0 open1 closed)

Blocks TYPO3 Core - Task #54725: Add Indexes to sys_file_referenceClosedIngo Schmitt2014-01-03

Actions
Actions #1

Updated by Gerrit Code Review over 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/26625

Actions #2

Updated by Gerrit Code Review over 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/26625

Actions #3

Updated by Gerrit Code Review over 10 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/26625

Actions #4

Updated by Markus Klein over 10 years ago

  • Subject changed from sys_file_reference.fieldname otimize colums to sys_file_reference.fieldname optimize columns
Actions #5

Updated by Steffen Ritter over 10 years ago

  • Parent task set to #51094
Actions #6

Updated by Gerrit Code Review over 10 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/26625

Actions #7

Updated by Ingo Schmitt over 10 years ago

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

Updated by Steffen Ritter over 10 years ago

  • % Done changed from 100 to 90
Actions #9

Updated by Steffen Ritter about 10 years ago

  • Assignee set to Ingo Schmitt
Actions #10

Updated by Steffen Ritter about 10 years ago

  • % Done changed from 90 to 100
Actions #11

Updated by Riccardo De Contardi over 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF