[TYPO3-dev] Typo3 Performance

[Martin Kutschker]

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.

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

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.

Masi