Bug #100035
closedDataHandler: Unnecessary database updates may result in timeout
100%
Description
- 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.
Updated by Gerrit Code Review almost 2 years ago
- Status changed from In Progress to Under Review
Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/77948
Updated by Gerrit Code Review almost 2 years ago
Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/77948
Updated by Gerrit Code Review almost 2 years ago
Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/77987
Updated by Andreas Fernandez almost 2 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 084335fe0de96e413d94ef529bd385a163f2a3ea.