Project

General

Profile

Actions

Bug #77676

closed

Workspace queries are done but workspace extension is deactivated

Added by Philipp Ulrich over 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Workspaces
Target version:
-
Start date:
2016-08-29
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

In database table tx_news_model_domain_news are about 180.000 entries. In one specific category are about 100.000 news. When new news record is added to this category, the backend calls for each news record of this category the query: SELECT t3ver_wsid FROM sys_category WHERE uid=5 AND sys_category.deleted=0 LIMIT 1
In TCA of tx_news_model_domain_news versioningWS is true but workspace extension is deactivated

And this happens about 100.000 times.

The workspace extension is deactivated, so normaly this queries shouldn't called.


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #64253: Fix incorrect calculation of file references in workspacesClosed2015-01-13

Actions
Actions #1

Updated by Andreas Kienast over 7 years ago

  • Is Regression changed from No to Yes
Actions #2

Updated by Gerrit Code Review over 7 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49628

Actions #3

Updated by Andreas Wolf over 7 years ago

I investigated this together with Philipp. The culprit is the method ReferenceIndex::createEntryData(), which was changed in commit abee33c5a35a23a9aec8234b73952a33ff8eb8b2.

A quick fix for this particular situation is to disable the check if EXT:workspace is not installed. The actual underlying issue however is that the same information is requested again and again. We could do a local micro-cache here for the t3ver_wsid, but I’m not sure if that is really practical.

Actions #4

Updated by Gerrit Code Review about 7 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49628

Actions #5

Updated by Gerrit Code Review about 7 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49628

Actions #6

Updated by Gerrit Code Review about 7 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/49628

Actions #7

Updated by Andreas Fernandez about 7 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #8

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF