Bug #77676: Workspace queries are done but workspace extension is deactivated - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #77676

closed

Workspace queries are done but workspace extension is deactivated

Added by Philipp Ulrich about 8 years ago. Updated about 6 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 open — 1 closed)

Actions

Copy link

Updated by Andreas Kienast about 8 years ago

Is Regression changed from No to Yes

Actions

Copy link

Updated by Gerrit Code Review about 8 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

Copy link

Updated by Andreas Wolf about 8 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

Copy link

Updated by Gerrit Code Review almost 8 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

Copy link

Updated by Gerrit Code Review almost 8 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

Copy link

Updated by Gerrit Code Review over 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

Copy link