[TYPO3] [Typo3] How large of website can typo3 handle?

[Bernhard Kraft]

Dennis Cheung wrote:


> Even we better choice.
> http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
> long inner join and Nested Set Model are useful to reduce total number
> of queries.

This is VERY interesting !

I programmed hierarchial structures inside relational database for half a decade
now ... and I knew that there was something around called nested sets ... but
I never saw such a clear and easy to understand (or pherhaps just my apprehension
has improved :) description of this method.


If I find some time I will try to make a patch for CVS version of T3 which replaces
the parent-method to store the pages table by this approach ... but this will require
a lot of changes in many core methods (all which access pages by their parent :(


Let's look what speed improvement comes out ... But please note that changing this would
break all extensions already messing around with the pages table not using the API methods.

(AFAIK currently there exist no API methods to "create" a page except tcemain - so if anybody
creates/deletes pages in his extension and not uses the API methods but plain exec_DELETEquery
or exec_INSERTquery's those extensions will all break ...

So pherhaps this would be fine for T3 5.0 :)



greets,
Bernhard