Project

General

Profile

Actions

Bug #43102

closed

Performance flaw when publishing content/pages in huge pagetrees

Added by Frank Gerards about 12 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Workspaces
Target version:
-
Start date:
2012-11-19
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.5
PHP Version:
5.3
Tags:
Complexity:
medium
Is Regression:
No
Sprint Focus:

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.


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #62208: ExtJS connection timeout when "Publish To Live"Closed2014-10-14

Actions
Actions

Also available in: Atom PDF