> Yes, and an edge list model may perform better in other respects too: > > http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html > http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html >
Thanks. I am currently reading "Trees and Hierarchies in SQL for Smarties" by Joe Celko, which also deals with a similar model. It is revealing and an interesting way of looking at the issue of organising data. In addition to those two links, this one also seems relevant: http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org