Bug #43102
closed
Performance flaw when publishing content/pages in huge pagetrees
0%
Description
Hi,
we have(had) the problem, that when publishing content elements/pages in 4.5.x (also in 4.6 and 4.7) we ran into some database timeouts/problems,
because the page tree is reloaded synchronically during the page publishing. With a pagetree of about 35.000 pages and 6 tree-levels this seems to
lock the pages/tt_content tables so some publish record actions got lost along the way as the DB engine MyISAM is not transaction-safe.
I patched the EXT:workspaces/Resources/Public/JavaScript/actions.js , thus moving the "top.TYPO3.Backend.NavigationContainer.PageTree.refreshTree();" statement from line 134 to 200 inside the handleResponse function.
This makes the page tree reload AFTER the publishing database operations have been done.
Would suggest this for every action in actions.js as it prevents any data loss, especially when using TemplaVoila.
Updated by Michael Stucki over 10 years ago
- Category changed from Bugs to Workspaces
Updated by Michael Stucki over 10 years ago
- Project changed from 624 to TYPO3 Core
- Category changed from Workspaces to Workspaces
Updated by Mathias Schreiber over 9 years ago
- Target version changed from 4.5.23 to 7.4 (Backend)
- Is Regression set to No
Updated by Mathias Schreiber over 9 years ago
- Target version changed from 7.4 (Backend) to 7.5
Updated by Oliver Hader over 8 years ago
- Assignee set to Oliver Hader
- Target version changed from 7.5 to 7 LTS
- Complexity set to medium
Will have a look into your finding...
Updated by Riccardo De Contardi over 6 years ago
actions.js should have been removed in version 8 (IIRC).
Updated by Oliver Hader over 6 years ago
- https://github.com/TYPO3/TYPO3.CMS/blob/TYPO3_4-5/typo3/sysext/workspaces/Resources/Public/JavaScript/actions.js
- https://github.com/TYPO3/TYPO3.CMS/blob/TYPO3_8-7/typo3/sysext/workspaces/Resources/Public/JavaScript/Backend.js
Looks like it is solved in TYPO3 CMS 8 LTS since Backend.refreshPageTree() is only called the XHR invoked with Workspaces.sendRemoteRequest is done
Updated by Oliver Hader over 6 years ago
- Status changed from New to Resolved
Please reopen this issue if you experience further problems with refreshing the page-tree. Thanks
Updated by