[TYPO3-core] RFC: #11271: Use 2 level cache for BEgetRootLine

[Martin Kutschker]

Dmitry Dulepov schrieb:
> Hi!
> 
> Martin Kutschker wrote:
>> It won't. The code to invalidate the cache is missing (see thread).
> 
> I guessed so... I read the thread but it is hard to follow.
> 
> A problem with tagging will also be that moving 1B from my example will invalidate three caches (any page that has 1B in its rootline). In case of a large tree it can be a huge number of pages.

I wouldn't go for removing individual tags but clear the cache for the
identifier "BErootline".

> I still think that we can add nested sets to our page tree and use that to fetch the whole rootline at once. It takes a single query on two indexed integer fields! (Well, we need to think about MPs too)

The only problem of nested sets in TYPO3 are the mount points, but this
doesn't matter for the BE as these are (currently) never resolved.

Masi