Posted by gosha bine on 06/06/07 18:16

On 06.06.2007 15:11 Steve wrote:
> I have been studying the Adjacency List Model as a means of achieving
> a folder structure in a project I am working on. Started with the
> excellent article by Gijs Van Tulder
>
> http://www.sitepoint.com/article/hierarchical-data-database
>
> [snip]
>
>
> Any ideas?
>

Doesn't this article also explain why you should NOT use adjacency
lists? With recursive queries you're doing N selects to fetch N
elements, that makes using database essentially pointless. From my
experience, ALs are only suitable for very small sets, which can be read
once completely and then processed in memory.


--
gosha bine

extended php parser ~ http://code.google.com/p/pihipi
blok ~ http://www.tagarga.com/blok

[Back to original message]