Task #45532
closed
Improve FAL performance
100%
Description
FAL performance in BE and FE can be improved by using certain database indexes.
One set of indexes improves performance in BE by adding a "deleted" column, which is used by List module. Without this column in the 'pid' index, List module will do a full scan, which is much slower.
Another set of indexes improves performance when getting files from storage.
Files
Updated by Georg Ringer almost 12 years ago
you wanna push that to gerrit as well?
Updated by Dmitry Dulepov almost 12 years ago
Yes. I am on the move, so I have connection only for few moment today.
Updated by Gerrit Code Review almost 12 years ago
- Status changed from New to Under Review
Patch set 1 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/18316
Updated by Gerrit Code Review almost 12 years ago
Patch set 2 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/18316
Updated by Gerrit Code Review over 11 years ago
Patch set 3 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/18316
Updated by Dmitry Dulepov over 11 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 76ec357369a460f35b16b65f32773f421859d903.
Updated by