[TYPO3-workspace] function selectAllVersionsFromPages is slowing down cause huge queries

[bernd wilke]

Am 09.04.15 um 11:56 schrieb TSniper:
> Hello,
>
> in workspaceservice.php we have this function :
>
> protected function selectAllVersionsFromPages($table, $pageList, $wsid,
> $filter, $stage, $language = NULL) {
> I think that function is causing issues or maybe something else:
>
> it is loading and loading again every time we change something.
> http://www.domain.de/typo3/ajax.php?ajaxID=ExtDirect::route&namespace=TYPO3.Workspaces
>
>
> 200 OK 28,62s
> Some times takes 28 sometimes sometimes more and there are timeouts
> connection abort.
>
> The page tree have same problem :
> http://www.domain.de/typo3/ajax.php?ajaxID=ExtDirect::route&namespace=TYPO3.Components.PageTree
> :: Aborted :: 29,8s
>
> How can i optimize this query.
> BTW: my database has about 6 years old so with such query it gonne try
> to load 45K of rows.
>
> I'm lost, i want to optimize the workspace so it will be faster to load
> contents and page tree too.
> Thanks a lot in advance for any help.

maybe you can optimize your installation at all.
we don't use workspaces but the BE performance sometimes is very slow also.

first: clean up the user-configuration. in the user configuration the 
complete state of the(un)expanded pagetree is stored. for big pagetrees 
this is a lot of data to prozess. and the pagetree is redrawn very often 
in the BE.
in the same way 'deleted' records may slow down your request as TYPO3 
does not really delete records but only marks them as deleted. queries 
may include these records which might need RAM and performance to filter 
them afterwards.
Also logs may slow your BE:
appending one line to a very big log is very slow!
make sure you rotate your apache logs. switch off deprecation log!

bernd
-- 
http://www.pi-phi.de/cheatsheet.html