Project

General

Profile

Actions

Bug #78629

closed

Updating reference indexes during record operations consumes thousands of SQL queries

Added by Claus Due over 7 years ago. Updated about 7 years ago.

Status:
Rejected
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2016-11-09
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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.

Actions

Also available in: Atom PDF