Project

General

Profile

Actions
Copy link

Bug #100035

closed

DataHandler: Unnecessary database updates may result in timeout

Added by Andreas Kienast about 1 year ago. Updated about 1 year ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
DataHandler aka TCEmain
Target version:
-
Start date:
2023-02-26
Due date:
% Done:

100%

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

Description

Scenario given:
  • A content element of type "Image" with ~80 referenced images
  • A shared hosting webspace with a 6-core CPU
  • A remote database with unknown specs

Even without any changes, saving the content element always results in a server-side timeout.
Side note: Increasing the timeout is impossible without paying the hosting provider extra money.

I discovered that unnecessary database updates are done for each(!) referenced element as the DataHandler internally switches t3ver_stage to "0" to start a new editing workflow. However, this is done after DH checked whether field updates are necessary at all.

Actions
Copy link

Also available in: Atom PDF