[TYPO3-dev] Typo3 Performance

[R. van Twisk]

Hey martin and others,

I made a small extension that updates the lid/rid for Celko's nested set 
on the pages table.
Where can I upload it? TER?

on a 395 page tree it takes around 285ms to update a complete pagetree.
This around 0.75ms per page (on my server ofcourse...)

The current code is not optimized for speed and there are no
indexes set on the lid and the rid.


Feel free to contact me and please let me know where I can
upload this extension.

thanks,
Ries van Twisk



> Dmitry Dulepov schrieb:
>   
>> R. van Twisk wrote:
>>     
>>> As you can see, adding a page, or moving is expensive, the following 
>>> schema can be
>>> used to make it less expensive..
>>>       
>> In fact, moving and adding is so rare thing (compared to viewing) that 
>> it can be optimized later.
>>
>>     
>>> What I can do is created this extension:
>>> tx_nestedset_pages -> add and maintains a nested set model on the 
>>> pages table.
>>>       
>> Using tcemain hooks, right?
>>     
>
> I hope so :-)
>
> BTW, we could add nested set to all tables if we define a TCA setting 
> for it. If you want to you can make the names of "left/right" columns 
> configurable but IMHO it's ok to use fixed names. What about "lid" and 
> "rid" in gool ol' TYPO3 style?
>
> Masi
>