Updating reference indexes during record operations consumes thousands of SQL queries
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.
#6 Updated by Wouter Wolters over 3 years ago
From the Gerrot review:
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...