On 25/11/2011 04:40, "Markus Malkusch" <[email protected]> wrote:
>Hello > >I remember that at the Magnolia training a limitation of siblings was >mentionend. The trainer said that above a certain amount of siblings >(which I >forgot) a performance impact of Jackrabbit will be noticed. > >My setting is Jackrabbit with MySQL (development) or MS-SQL (productive) >and >Magnolia Community Edition 4.4.4. How many siblings can be on one JCR >level? > >Regards >Markus The JackRabbit developers claim that performance degrades heavily beyond around 10K child nodes. My own experience is that performance (especially writes) suffers after about 1K child nodes, and it just progressively gets worse. JackRabbit maintains an array of references to child nodes in the parent node (I believe that is how node ordering is maintained internally), and every node add/delete will require this array to be updated leading to the performance issue. Rakesh ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
