Bug #24950
closed
Large subtrees in the pagetree wont open
0%
Description
Large subtrees (e.g. 800 pages) in the pagetree wont open due to timeout constraints. E.g. in the new Chrome 9 nothing happens. In Firefox 3.6.x you get a connection problem. The db query to select the subpages takes 0.x seconds, so no DB problem.
(issue imported from #M17477)
Updated by Stefan Galinski almost 14 years ago
Please test with the latest trunk again. A major performance problem was solved currently.
Updated by Klaus Hinum almost 14 years ago
It looks like to be a speed issue, as with less database load, the tree works (but is incredible slow). Is there a 4.5.1 planned soon (as I cant use and test the trunk in our productive system)?
Updated by Steffen Gebert almost 14 years ago
4.5.1 is scheduled for March 09th.
Why not use the subversion checkout of the 4.5 branch? It already contains the fixes, which get into 4.5.1
Updated by Klaus Hinum almost 14 years ago
Just tried the subversion checkout from Sunday 20.Feb. The performance got a bit better, but still the database is flooded every day with queries after some time (slow connections from other users I guess). The users report that they get connection problem warnings and the whole tree isn't loaded anymore. We have to restart Apache to reset the database load. Somehow the pagetree may stall and produce queries without timeouts.
Updated by Klaus Hinum over 13 years ago
Small update, we now found the problem, when automatically creating pages, the pagetree somehow looses connection and even stalls with this message:
Connection Problem
Sorry, but an error occurred while connecting to the server. Please check your network connection.
The pagetree window remains empty and Connection Problem windows keep appearing.
Updated by Stefan Galinski over 13 years ago
The timeout comes from the ExtDirect component and is internally set to 30 seconds. However one question: What do you mean with "automatically creating pages"?
Updated by Klaus Hinum over 13 years ago
We have a script that is creating a number of pages and resorting them. This script runs in parallel sometimes creating a bit of a stress to the database. However, up to 4.5 no impact on the backend performance was noticable.
Another issue with the latest version: After some adding / updating some extensions the pagetree wasn't loading at all (development and production server). Even after re-login and for all users (Connection Problem error). We had to revert to the 4.5.0 version. The Connection Problem btw. occured before 30s time passed, so I guess no connection anymore.
Is there a possiblity to change the 30s timeout?
Updated by Jochen Rieger over 13 years ago
- Target version deleted (
0)
Any news on this one?
We also experience "Connection Error" problems, using 4.5.4 with a quite large page tree (around 2.000 pages). Mainly the error occurs, when copying a branch via page tree copy / paste (via drag'n drop as well as via clickmenu copy / pase).
Updated by Alexander Opitz about 10 years ago
- Description updated (diff)
- Status changed from New to Needs Feedback
- Is Regression set to No
Hi,
as this issue is very old. Does the problem still exists within newer versions of TYPO3 CMS (6.2.4)?
Updated by Klaus Hinum about 10 years ago
looks like its fixed with the 6.2 update and above. The page tree is still very slow (often more than 5 sec to open a subtree with a fast connection to a fast server) but now at least working.
Updated by Alexander Opitz about 10 years ago
Ok, how many pages do you have in there?
Can you check if your database may have issues handling it?
Updated by Alexander Opitz almost 10 years ago
- Status changed from Needs Feedback to Closed
No feedback within the last 90 days => closing this issue.
If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.