Project

General

Profile

Actions
Copy link

Bug #47692

closed

Changing the page header results in cache clears of all pages in the same directory

Added by Klaus Hinum over 11 years ago. Updated almost 10 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Backend API
Target version:
-
Start date:
2013-04-29
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.0
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

When changing fields of the page header (e.g. title) using the tce (process_datamap function) in an own extension, all caches of the pages in the same directory are deleted. As we got hundreds of pages in the same directory, the process takes very long (up to two minutes).
Mysql logs the following queries for each page in the same folder
137 Query SELECT DISTINCT identifier FROM cf_cache_hash_tags WHERE cf_cache_hash_tags.tag = 'pageId_37382'
137 Query DELETE FROM cf_cache_hash_tags WHERE cf_cache_hash_tags.tag = 'pageId_37382'
137 Query SELECT DISTINCT identifier FROM cf_extbase_object_tags WHERE cf_extbase_object_tags.tag = 'pageId_37382'
137 Query DELETE FROM cf_extbase_object_tags WHERE cf_extbase_object_tags.tag = 'pageId_37382'
137 Query SELECT DISTINCT identifier FROM cf_cache_pages_tags WHERE cf_cache_pages_tags.tag = 'pageId_37382'
137 Query DELETE FROM cf_cache_pages_tags WHERE cf_cache_pages_tags.tag = 'pageId_37382'
137 Query SELECT DISTINCT identifier FROM cf_cache_pagesection_tags WHERE cf_cache_pagesection_tags.tag = 'pageId_37382'
137 Query DELETE FROM cf_cache_pagesection_tags WHERE cf_cache_pagesection_tags.tag = 'pageId_37382'
137 Query SELECT DISTINCT identifier FROM cf_cache_rootline_tags WHERE cf_cache_rootline_tags.tag = 'pageId_37382'
137 Query DELETE FROM cf_cache_rootline_tags WHERE cf_cache_rootline_tags.tag = 'pageId_37382'
137 Query SELECT DISTINCT identifier FROM cf_extbase_reflection_tags WHERE cf_extbase_reflection_tags.tag = 'pageId_37382'
137 Query DELETE FROM cf_extbase_reflection_tags WHERE cf_extbase_reflection_tags.tag = 'pageId_37382'
137 Query SELECT DISTINCT identifier FROM cf_extbase_typo3dbbackend_tablecolumns_tags WHERE cf_extbase_typo3dbbackend_tablecolumns_tags.tag = 'pageId_37382'
137 Query DELETE FROM cf_extbase_typo3dbbackend_tablecolumns_tags WHERE cf_extbase_typo3dbbackend_tablecolumns_tags.tag = 'pageId_37382'
137 Query SELECT DISTINCT identifier FROM cf_extbase_datamapfactory_datamap_tags WHERE cf_extbase_datamapfactory_datamap_tags.tag = 'pageId_37382'
137 Query DELETE FROM cf_extbase_datamapfactory_datamap_tags WHERE cf_extbase_datamapfactory_datamap_tags.tag = 'pageId_37382'

Actions
Copy link

Also available in: Atom PDF