Bug #78629
closed
Updating reference indexes during record operations consumes thousands of SQL queries
0%
Description
When the DataHandler is allowed to update reference indexing and is asked to do recursive copy operations, it triggers thousands upon thousands of SQL queries even for a limited set (26 pages, ~100 content records, no translations).
It would be wise to add a configuration option to disable this forced reference index updating, and follow that up with a scheduler task to update all reference indexes without slowing down record operations. The option itself can be allowed on 7.6 LTS to be used by site administrators who are able to take the necessary precautions to update the index.
Updated by Gerrit Code Review over 7 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/50559
Updated by Gerrit Code Review over 7 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/50559
Updated by Gerrit Code Review over 7 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/50559
Updated by Anja Leichsenring over 7 years ago
- Status changed from Under Review to Rejected
Updated by José Ricardo about 7 years ago
Why was this rejected? I have a similar problem at #80800
Updated by Wouter Wolters about 7 years ago
From the Gerrot review:
Abandoned
Since four people now mentioned their concerns on disabling the reference index, I'm closing this change. It's more a candidate for a custom and local XCLASS instead of adding side-effects to the TYPO3 core. Thanks for your understanding...