[TYPO3-dev] Typo3 Performance

[Dmitry Dulepov]

Martin Kutschker wrote:
> Dmitry Dulepov schrieb:
>> Hi!
>>
>> Martin Kutschker wrote:
>>> Can you explain this model in short or give me a pointer to an online 
>>> resource?
>>
>> This model was proposed by Oracle DB expert Joe Celko. Generally it 
>> marks branches of the tree with consecutive numbers so that when you 
>> want to fetch root path or get the whole branch, you just need to 
>> issue query with two numbers. Example:
>>
>>                     |- C (3,4)
>>         |- B (2, 7)-|
>> A(1,14)-|           |- D (5,6)
>>         |           |
>>         |- E (8,13)-|- F (9,10)
>>                     |
>>                     |- G (11,12)
> 
> Quite interesting.
> 
> I notice that several articles on this topic suggest to use table locks 
> (for Myisam) or transactions when updating the table. This makes sense 
> but forces us to deal with a Myisam vs Innodb issue plus a DBAL issue.

No need. Updates can be also done with one or two queries. I see the 
issue with hidden/deleted pages only...

> Still it's interesting to see which features of TYPO3 can be sped up 
> with queries on the nested sets.

Realurl, for example :) It takes rootline. And any other function that 
requires to traverse tree (templavoila too).

> But I wonder what will happen if you have thousands of pages. Maybe it 
> makes sense to have a separate set for each root page (ie a page with 
> pid=0). So changes in one domain won't affect other domains.

Yes, we should assume that every page start from page with uid=0 (may be 
we should have one in database).

-- 
Dmitry Dulepov

Web: http://typo3bloke.net/
Skype: callto:liels_bugs

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)