Task #54726

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 1 year ago. Updated over 1 year ago.

Status:Resolved Start date:2014-01-03
Priority:Should have Due date:
Assigned To:Ingo Schmitt % Done:

100%

Category:Performance Spent time: -
Target version:6.2.0
TYPO3 Version:6.2 Complexity:
PHP Version: 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

blocks Core - Task #54725: Add Indexes to sys_file_reference Resolved 2014-01-03

Associated revisions

Revision 9e88bf74
Added by Ingo Schmitt over 1 year ago

[TASK] Optimize columns in sys_file_reference

MySQL up to version 5.5 allows at maximum 64 characters for table-
and fieldnames. Other DBMS allow less. Since MySQL is our primary
database and DBAL could handle specialties.

This patch changes the fields tablenames, fieldname and table_local
to varchar(64) which currently is considered save.

Resolves: #54726
Releases: 6.2
Change-Id: Ic67450a9326dceb413fe694a6233b8c092f70c79
Reviewed-on: https://review.typo3.org/26625
Reviewed-by: Steffen Ritter
Tested-by: Steffen Ritter

History

#1 Updated by Gerrit Code Review over 1 year 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

#2 Updated by Gerrit Code Review over 1 year 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

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

#4 Updated by Markus Klein over 1 year ago

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

#5 Updated by Steffen Ritter over 1 year ago

  • Parent task set to #51094

#6 Updated by Gerrit Code Review over 1 year 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

#7 Updated by Ingo Schmitt over 1 year ago

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

#8 Updated by Steffen Ritter over 1 year ago

  • % Done changed from 100 to 90

#9 Updated by Steffen Ritter over 1 year ago

  • Assigned To set to Ingo Schmitt

#10 Updated by Steffen Ritter over 1 year ago

  • % Done changed from 90 to 100

Also available in: Atom PDF