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 #1

Updated by Michael Stucki almost 11 years ago

  • Category changed from Bugs to Workspaces
Actions #2

Updated by Michael Stucki almost 11 years ago

  • Project changed from 624 to TYPO3 Core
  • Category changed from Workspaces to Workspaces
Actions #3

Updated by Mathias Schreiber almost 10 years ago

  • Target version changed from 4.5.23 to 7.4 (Backend)
  • Is Regression set to No
Actions #4

Updated by Mathias Schreiber almost 10 years ago

  • Target version changed from 7.4 (Backend) to 7.5
Actions #5

Updated by Oliver Hader about 9 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...

Actions #6

Updated by Mathias Schreiber about 9 years ago

  • Target version deleted (7 LTS)
Actions #7

Updated by Riccardo De Contardi about 7 years ago

actions.js should have been removed in version 8 (IIRC).

Actions #8

Updated by Oliver Hader about 7 years ago

Looks like it is solved in TYPO3 CMS 8 LTS since Backend.refreshPageTree() is only called the XHR invoked with Workspaces.sendRemoteRequest is done

Actions #9

Updated by Oliver Hader about 7 years ago

  • Status changed from New to Resolved

Please reopen this issue if you experience further problems with refreshing the page-tree. Thanks

Actions #10

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF