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

Peter Niederlag typo3-list at niekom.de
Fri Jun 5 15:28:40 CEST 2009


Hello,

Dmitry Dulepov schrieb:
> Hi!
[...]
> I think we should go another way. We are trying to cure the
> consequences of the problem, not the problem itself. The consequences
> is that BEgetRootline is slow. The cause is multiple queries. Should
> we cure the cause instead? 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)
> 
> If pages are rearranged, updating nested set markers is easy (another
> single query). And we do not need any cache at all.

Thx! Yes, please, please go this way!
curing the issues of adjacent-list model by adding/managing caches is
putting so much effort fully on the wrong end!

my 2 cent,
Peter
-- 
Peter Niederlag
http://www.niekom.de * TYPO3 & EDV Dienstleistungen *


More information about the TYPO3-team-core mailing list