#106013Extbase Query Performance Issue
Description
We updated one project with one Extension to 13 and run into timeouts.
The issue could be tracked down to the transformation of the Extbase Query to the Doctrine Query.
We opened a PR within the Extension with a test to reproduce the issue: https://github.com/werkraum-media/events/pull/73
The whole test is executed faster than one second in v12, but runs into timouts in v13: https://github.com/werkraum-media/events/actions/runs/13027802430/job/36340287193?pr=73 “2m 12s” for all tests in v12 vs. “47m 3s” on v13.
I can’t attach the kcachegrind files as they are larger than the allowed maximum. But maybe the Screenshot already helps.
It seems right now not possible to execute Extbase Queries with multiple or concatenated contains over a sys_category relation. This seems to be a regression in v13.
Reviews 3
Related issues 2
Files 3
History 2226
Show 1 earlier messages
-
Garvin Hicking commented <span data-processor="relativetime" data-value="2025-01-29T15:38:07+00:00" > 01/29/25, 15:38 </span>
-
Garvin Hicking commented <span data-processor="relativetime" data-value="2025-01-29T15:40:22+00:00" > 01/29/25, 15:40 </span>
(Given that the SQL query even gets built – or it times out beforehand even, do I understand right?)
-
Daniel Siepmann commented <span data-processor="relativetime" data-value="2025-01-29T17:50:13+00:00" > 01/29/25, 17:50 </span>
Yeah, it times out before it is ready build. It seems like the parsing of constraints doesn’t scale well anymore. The more constraints, the longer it takes.
E.g. in the test, reducing the available sys_category entries would lead to a time that you won’t notice.
-
Georg Ringer commented and changed status
NewAccepted assigned to Stefan Bürk <span data-processor="relativetime" data-value="2025-01-29T20:09:17+00:00" > 01/29/25, 20:09 </span>stefan will look at that as soon as he is back online
-
Daniel Siepmann commented <span data-processor="relativetime" data-value="2025-01-30T07:49:26+00:00" > 01/30/25, 07:49 </span>
This is the executed SQL on v12:
SELECT count(*) FROM `tx_events_domain_model_date` `tx_events_domain_model_date` LEFT JOIN `tx_events_domain_model_event` `tx_events_domain_model_event` ON `tx_events_domain_model_date`.`event` = `tx_events_domain_model_event`.`uid` WHERE (((((((not(`tx_events_domain_model_event`.`uid` IS NULL)) AND (`tx_events_domain_model_date`.`uid` > 0))) AND (((((((((((((((((((((((((((((((((((((((((((((((`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '1') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '2') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '3') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '4') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '5') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '6') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '7') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '8') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '9') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '10') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '11') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '12') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '13') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '14') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '15') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '16') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '17') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '18') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '19') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '20') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '21') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '22') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '23') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '24') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))))) AND (((`tx_events_domain_model_date`.`start` >= '1660158000') OR (`tx_events_domain_model_date`.`end` >= '1660158000'))))) AND (`tx_events_domain_model_date`.`sys_language_uid` IN (0, -1)) AND (`tx_events_domain_model_date`.`pid` = 2) AND (`tx_events_domain_model_date`.`t3ver_oid` = 0) AND (((`tx_events_domain_model_date`.`t3ver_state` <= 0) AND (`tx_events_domain_model_date`.`t3ver_wsid` = 0) AND (((`tx_events_domain_model_date`.`t3ver_oid` = 0) OR (`tx_events_domain_model_date`.`t3ver_state` = 4))) AND (`tx_events_domain_model_date`.`hidden` = 0) AND (`tx_events_domain_model_date`.`starttime` <= 1738223280) AND (((`tx_events_domain_model_date`.`endtime` = 0) OR (`tx_events_domain_model_date`.`endtime` > 1738223280))))) AND (((((`tx_events_domain_model_event`.`deleted` = 0) AND (`tx_events_domain_model_event`.`t3ver_state` <= 0) AND (`tx_events_domain_model_event`.`t3ver_wsid` = 0) AND (((`tx_events_domain_model_event`.`t3ver_oid` = 0) OR (`tx_events_domain_model_event`.`t3ver_state` = 4))) AND (`tx_events_domain_model_event`.`hidden` = 0) AND (`tx_events_domain_model_event`.`starttime` <= 1738223280) AND (((`tx_events_domain_model_event`.`endtime` = 0) OR (`tx_events_domain_model_event`.`endtime` > 1738223280))))) OR (`tx_events_domain_model_event`.`uid` IS NULL))) AND (((`tx_events_domain_model_date`.`t3ver_wsid` = 0) AND (((`tx_events_domain_model_date`.`t3ver_oid` = 0) OR (`tx_events_domain_model_date`.`t3ver_state` = 4))))) -
Garvin Hicking commented <span data-processor="relativetime" data-value="2025-01-30T08:13:59+00:00" > 01/30/25, 08:13 </span>
Ouch, this looks bad. Can you say where exactly this gets issued? I assume on an extbase domain repository relation property mapping? Your tests only executes a subrequest, I guess that one uses a specific extbase findBy/findAll() method?
This might help Stefan to easier setup a reproducible example if we can recreate the extbase circumstances.
Haven’t look into it myself, feels a bit like this query should not have X subqueries but rather X left outer joins with a single query to return the UIDs for a “uid in (….)” condition…?
-
Garvin Hicking commented <span data-processor="relativetime" data-value="2025-01-30T08:23:10+00:00" > 01/30/25, 08:23 </span>
Guess https://github.com/werkraum-media/events/blob/main/Classes/Domain/Repository/EventRepository.php#L147-L151 is at work here?
$categories = GeneralUtility::intExplode(',', $categories, true); foreach ($categories as $category) { $constraints[] = $query->contains('categories', $category); }Wonder if you could use
$query->in('categories.uid', $categoryUidsinstead to make it perform more efficiently? -
Daniel Siepmann commented <span data-processor="relativetime" data-value="2025-01-30T08:43:59+00:00" > 01/30/25, 08:43 </span>
Yes exactly. From my understanding this won’t be possible, as one event can have multiple categories assigned, that’s why one needs to use contains().
This is a query from v13, when I remove some sys_category form the database:
SELECT count(*) FROM `tx_events_domain_model_date` LEFT JOIN `tx_events_domain_model_event` `tx_events_domain_model_event` ON `tx_events_domain_model_date`.`event` = `tx_events_domain_model_event`.`uid` WHERE ((((((not(`tx_events_domain_model_event`.`uid` IS NULL)) AND (`tx_events_domain_model_date`.`uid` > 0))) AND (((((((`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '1') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '2') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '3') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))) OR (`tx_events_domain_model_event`.`uid` IN (SELECT `uid_foreign` FROM `sys_category_record_mm` WHERE (`uid_local` = '4') AND (((`sys_category_record_mm`.`tablenames` = 'tx_events_domain_model_event') AND (`sys_category_record_mm`.`fieldname` = 'categories'))))))))) AND (((`tx_events_domain_model_date`.`start` >= '1660158000') OR (`tx_events_domain_model_date`.`end` >= '1660158000'))) AND (`tx_events_domain_model_date`.`sys_language_uid` IN (0, -1)) AND (`tx_events_domain_model_date`.`pid` = 2) AND (`tx_events_domain_model_date`.`t3ver_oid` = 0) AND (((`tx_events_domain_model_date`.`t3ver_state` <= 0) AND (`tx_events_domain_model_date`.`t3ver_wsid` = 0)) AND ((`tx_events_domain_model_date`.`t3ver_oid` = 0) OR (`tx_events_domain_model_date`.`t3ver_state` = 4)) AND `tx_events_domain_model_date`.`hidden` = 0 AND `tx_events_domain_model_date`.`starttime` <= 1738226160 AND ((`tx_events_domain_model_date`.`endtime` = 0) OR (`tx_events_domain_model_date`.`endtime` > 1738226160))) AND (((`tx_events_domain_model_event`.`deleted` = 0 AND ((`tx_events_domain_model_event`.`t3ver_state` <= 0) AND (`tx_events_domain_model_event`.`t3ver_wsid` = 0)) AND ((`tx_events_domain_model_event`.`t3ver_oid` = 0) OR (`tx_events_domain_model_event`.`t3ver_state` = 4)) AND `tx_events_domain_model_event`.`hidden` = 0 AND `tx_events_domain_model_event`.`starttime` <= 1738226160 AND ((`tx_events_domain_model_event`.`endtime` = 0) OR (`tx_events_domain_model_event`.`endtime` > 1738226160))) OR (`tx_events_domain_model_event`.`uid` IS NULL))) AND (((`tx_events_domain_model_date`.`t3ver_wsid` = 0) AND (((`tx_events_domain_model_date`.`t3ver_oid` = 0) OR (`tx_events_domain_model_date`.`t3ver_state` = 4))))))The v12 query works in under 1 second. So the query in general doesn’t seem to be an issue in v12.
But I’m also happy if there is a better approach. -
Garvin Hicking commented <span data-processor="relativetime" data-value="2025-01-30T08:51:36+00:00" > 01/30/25, 08:51 </span>
The ->in() condition when combined with a grouping of the model’s uid should be able to “fold” multiple join results, but you’re probably right this would be a workaround for the query creation process, and the difference from v12 to v13 in query generstion needs to be found.
I’ll be silent now and let Stefan have a look first, but maybe this small sidequest rings a bell for him ;-)
-
Garvin Hicking commented <span data-processor="relativetime" data-value="2025-01-30T19:57:59+00:00" > 01/30/25, 19:57 </span>
(Stefan: I’ve added a POC https://review.typo3.org/c/Packages/TYPO3.CMS/+/87945 to show what I mean with a “better” query for finding categories which would not use recursion. However I think this is just a sidequest/optimization; the root cause for this where Doctrine DBAL probably creates large resource exhaustion due to resursive object generation is still left. But I think, a `contains` here is not a good query to execute)
-
Daniel Siepmann commented <span data-processor="relativetime" data-value="2025-02-03T06:59:13+00:00" > 02/03/25, 06:59 </span>
Thanks, that might solve the issue when you only care about “or”, e.g. if any of the given categories is assigned to events. But that won’t work with an “and” if an event should be assigned to all of the categories, right?
-
Daniel Siepmann commented <span data-processor="relativetime" data-value="2025-02-05T10:49:12+00:00" > 02/05/25, 10:49 </span>
We now have your workaround for OR in our project, this works fine, as the project itself only uses the OR feature of the extension. Thanks for helping out.
-
Daniel Siepmann commented <span data-processor="relativetime" data-value="2025-02-24T14:56:44+00:00" > 02/24/25, 14:56 </span>
Now I’m running into:
(1/1) Error Maximum call stack size of 8339456 bytes (zend.max_allowed_stack_size - zend.reserved_stack_size) reached. Infinite recursion?
with PHP 8.3 and PHP 8.4. Within the `isEmptyPart()` method. With the workaround applied.
-
Andreas Stephan commented and changed attached TYPO3_134_115_difference.png attached qcachegrind.png <span data-processor="relativetime" data-value="2025-02-27T15:51:02+00:00" > 02/27/25, 15:51 </span>
We’re facing the same issue in TYPO3 13. The loading time of a page with an Extbase query using a logicalOr constraint containing 18 fields is 9 seconds. Example:
$queryConstraints[] = $query->logicalOr( $query->like('field1', $findText), $query->like('field2', $findText), ... ); $query->matching($query->logicalAnd(...$queryConstraints));Usually the logicalOr constraint contains 33 fields, but then the request times out in TYPO3 13, so for testing purposes we reduced it to 18 fields.
Before with TYPO3 11.5 the page loading time (with the logical constraint containing 33 fields) is less than a second.After some debugging this seems to be caused by the static method CompositeExpression::isEmptyPart (see attached screenshot), respectively its excessive calls of CompositeExpression::__toString (every __toString call then calls isEmptyPart again).
When I change back the isEmptyPart calls to is_null calls for testing purposes, the loading time is less than a second again.Please see the attached qcachegrind screenshot, too.
Another hint for class CompositeExpression: 4 of the 5 array_filter calls are completely ignoring the function’s result. The first argument of array_filter isn’t passed by reference, so for me it seems these function calls are completely useless at the moment. Am I missing something?
(TYPO3 13.4.5, PHP 8.4.4)
-
Tobias Quadflieg commented <span data-processor="relativetime" data-value="2025-04-11T08:32:55+00:00" > 04/11/25, 08:32 </span>
Has anything changed here? We have several TYPO3 upgrades where we have the problem and we would like to avoid adding an own class everywhere to temporarily fix the problem.
ty!
-
Garvin Hicking commented <span data-processor="relativetime" data-value="2025-04-11T12:53:06+00:00" > 04/11/25, 12:53 </span>
@hrdyy so you’ve fixed the issues via xclasses? Please share them, then progress could be made :-)
-
Gerrit Code Review pushed patch set 5 for main to change 89139 status
AcceptedUnder Review <span data-processor="relativetime" data-value="2025-04-17T11:39:55+00:00" > 04/17/25, 11:39 </span> -
Stefan Bürk commented <span data-processor="relativetime" data-value="2025-04-17T11:47:22+00:00" > 04/17/25, 11:47 </span>
layne.obserdiahrdyy @ans-hwI investigated this now, and used a cli command with a setup to
do measurements as baseline with TYPO3 v12 and v13/main and also
while doing changes.Note that the command test is quite constructed, and having that
much stuff going on there will be a lot of other issues before,
like memory usage (in the gigabytes), and even if sql gets created
you will end up reaching max query size limits of databases.See attached change on gerrit, which includes multiple fixes and
reworkings to increase the performance again, not only to the v12
baseline but even more.Used command:
<?php declare(strict_types=1); namespace SBUERK\TestDummy\Command; use Symfony\Component\Console\Attribute\AsCommand; use Symfony\Component\Console\Command\Command; use Symfony\Component\Console\Input\InputInterface; use Symfony\Component\Console\Output\OutputInterface; use Symfony\Component\Stopwatch\Stopwatch; use TYPO3\CMS\Core\Database\Query\Expression\CompositeExpression; #[AsCommand(name: 'sbuerk:composite-expression-test')] final class CompositeExpressionTestCommand extends Command { private int $created = 0; private const MAX_LEVEL = 4; private const NUM_PARTS_TO_CREATE = 30; protected function execute(InputInterface $input, OutputInterface $output): int { $watch = new Stopwatch(true); $event = $watch->start('create'); $compositeExpression = $this->createCompositeExpression(); $output->writeln('Elapsed: ' . $event->stop() . ' CREATED: ' . $this->created); return Command::SUCCESS; } private function createCompositeExpression(int $level = 0): CompositeExpression { if ($level > self::MAX_LEVEL) { $this->created++; return CompositeExpression::or(...['dummy = 1']); } $nextLevel = $level + 1; $parts = []; for ($i=0; $i < self::NUM_PARTS_TO_CREATE; $i++) { $parts[] = $this->createCompositeExpression($nextLevel); $this->created++; } return CompositeExpression::or(...$parts); } }and here some more detaled stats over the different steps:
12.4: ===== MAX_LEVEL = 2 NUM_PARTS_TO_CREATE = 30 => 82 ms CREATED: 54930 MAX_LEVEL = 3 NUM_PARTS_TO_CREATE = 30 => 2492 ms CREATED: 1647930 MAX_LEVEL = 4 NUM_PARTS_TO_CREATE = 30 => 82346 ms CREATED: 49437930 main: ===== CURRENT: -------- MAX_LEVEL = 2 NUM_PARTS_TO_CREATE = 30 => 369 ms CREATED: 54930 MAX_LEVEL = 3 NUM_PARTS_TO_CREATE = 30 => 22991 ms CREATED: 1647930 MAX_LEVEL = 4 NUM_PARTS_TO_CREATE = 30 => ~ aborted Following are results after doing stuff, each step contains changes from above (stack): fixing array filter (ensure result is used + remove from __toString()) ---------------------------------------------------------------------- MAX_LEVEL = 2 NUM_PARTS_TO_CREATE = 30 => 79 ms CREATED: 54930 MAX_LEVEL = 3 NUM_PARTS_TO_CREATE = 30 => 3316 ms CREATED: 1647930 MAX_LEVEL = 4 NUM_PARTS_TO_CREATE = 30 => ~ aborted refactor CompositeExpression::isEmptyPart() (make early returns and use cheap checks first) ------------------------------------------------------------------------------------------- MAX_LEVEL = 2 NUM_PARTS_TO_CREATE = 30 => 51 ms CREATED: 54930 MAX_LEVEL = 3 NUM_PARTS_TO_CREATE = 30 => 1542 ms CREATED: 1647930 MAX_LEVEL = 4 NUM_PARTS_TO_CREATE = 30 => 53661 ms CREATED: 49437930 adding internal `isEmpty()` with simply array check (checking for empty array) ------------------------------------------------------------------------------ MAX_LEVEL = 2 NUM_PARTS_TO_CREATE = 30 => 50 ms CREATED: 54930 MAX_LEVEL = 3 NUM_PARTS_TO_CREATE = 30 => 1552 ms CREATED: 1647930 MAX_LEVEL = 4 NUM_PARTS_TO_CREATE = 30 => 53151 ms CREATED: 49437930 replaced isEmpty() instance method with inline property check (thanks to not wildy nown php support) ---------------------------------------------------------------------------------------------------- MAX_LEVEL = 2 NUM_PARTS_TO_CREATE = 30 => 49 ms CREATED: 54930 MAX_LEVEL = 3 NUM_PARTS_TO_CREATE = 30 => 1505 ms CREATED: 1647930 MAX_LEVEL = 4 NUM_PARTS_TO_CREATE = 30 => 53355 ms CREATED: 49437930 removing duplicate filtering from OR() and AND() (calling with(), keeping filter in that central method only) ------------------------------------------------------------------------------------------------------------- MAX_LEVEL = 2 NUM_PARTS_TO_CREATE = 30 => 38 ms CREATED: 54930 MAX_LEVEL = 3 NUM_PARTS_TO_CREATE = 30 => 1147 ms CREATED: 1647930 MAX_LEVEL = 4 NUM_PARTS_TO_CREATE = 30 => 41568 ms CREATED: 49437930
-
Stefan Bürk changed Related to #102875 <span data-processor="relativetime" data-value="2025-04-17T11:47:43+00:00" > 04/17/25, 11:47 </span>
-
Stefan Bürk changed category <span data-processor="relativetime" data-value="2025-04-17T11:47:52+00:00" > 04/17/25, 11:47 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 89139 <span data-processor="relativetime" data-value="2025-04-17T11:49:29+00:00" > 04/17/25, 11:49 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 89139 <span data-processor="relativetime" data-value="2025-04-17T13:35:29+00:00" > 04/17/25, 13:35 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 89160 <span data-processor="relativetime" data-value="2025-04-17T15:52:14+00:00" > 04/17/25, 15:52 </span>
-
Stefan Bürk commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-04-17T16:05:08+00:00" > 04/17/25, 16:05 </span>Applied in changeset commit:b7a5cee91c1184123e9b2340f39712e176ef3245.
-
Garvin Hicking changed Related to #106597 <span data-processor="relativetime" data-value="2025-04-22T15:55:03+00:00" > 04/22/25, 15:55 </span>
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:26:08+00:00" > 12/02/25, 14:26 </span>
Are you maybe able to check the SQL query that would get executed? Could it be the joins are missing groupBys or so?
Maybe through database-side query logging or slow queries. Then we could check the SQL resultset for abmormal dataset sizes or recursion or contained IDs that could cause extbase infinite recursion through language overlays or so…?