Bug #77676
closedWorkspace queries are done but workspace extension is deactivated
100%
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.
Updated by Andreas Kienast almost 8 years ago
- Is Regression changed from No to Yes
Updated by Gerrit Code Review almost 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
Updated by Andreas Wolf almost 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.
Updated by Gerrit Code Review over 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
Updated by Gerrit Code Review over 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
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
Updated by Andreas Fernandez over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset d7414f6167e6dc80de1e5a030158e6b12c92b24a.