TYPO3 Core

Hi Rhodri,
we have the same error after updating from 4.2 to 6.2. Looks like an SQL query takes very very long.

SELECT B.uid as live_uid, B.pid as live_pid, A.uid as offline_uid 
FROM tt_content A,tt_content B 
WHERE A.pid=-1 
AND A.t3ver_wsid=2 
AND 
(A.t3ver_oid=B.uid 
AND A.t3ver_state<>4 
OR A.t3ver_oid=B.t3ver_move_id 
AND A.t3ver_state=4) 
AND A.deleted=0 
AND B.deleted=0 
GROUP BY live_pid

We have fixed it by adding some extra indexes to the tt_content table:

ALTER TABLE `tt_content`
 ADD INDEX `pid` (`pid`),
 ADD INDEX `t3ver_wsid` (`t3ver_wsid`),
 ADD INDEX `t3ver_state` (`t3ver_state`),
 ADD INDEX `t3ver_move_id` (`t3ver_move_id`)
;

Give the patch in #69439 a try...

Can anybody say in which versions of TYPO3 this is fixed? Have the problem still in 7.6.29.

Thanks for the hint with the SQL indicies. Didn't make any difference though. So I've tried it with a combined index which boosted performance of said query (with TYPO3 8.7) by factor 20.000 or so. Instead of 45s it's only 0,00025s now ;-)

I've wrapped it into a tiny extension: https://packagist.org/packages/kitzberger/workspaces-boost

Maybe someone stumbles over this issue here and needs a quick solution for this.

Cheers, Philipp