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

[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.