On Jan 18, 2009, at 1:33 PM, Kless wrote:
> > If any is interested in tree structures, there is an excelent > implementation for django ORM, django-treebeard [2], which has > included any benchmarks where you can see the reading differences > between different structures. > > > [1] > http://www.sqlalchemy.org/docs/05/mappers.html#adjacency-list-relationships > [2] http://code.google.com/p/django-treebeard/ > also of note is that the django adjacency list example does not use joins to load multiple levels of parent/child nodes at once.. SQLAlchemy's relation() function (which means "relationship", the name's conflict with the relational term is an historic artifact) supports automatic rendering of self-referential joins which can dramatically decrease the number of round trips needed to load multiple levels of tree nodes. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---