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
100%
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.
Updated by Gerrit Code Review about 11 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
Updated by Gerrit Code Review about 11 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
Updated by Gerrit Code Review about 11 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
Updated by Markus Klein about 11 years ago
- Subject changed from sys_file_reference.fieldname otimize colums to sys_file_reference.fieldname optimize columns
Updated by
Updated by Gerrit Code Review about 11 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
Updated by Ingo Schmitt about 11 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 9e88bf746ac7d825d98396a50707cfeb968231fe.
Updated by Riccardo De Contardi over 7 years ago
- Status changed from Resolved to Closed