Hieratic Category Query

Hieratic Category Query

El Forum
Unregistered

03-15-2008, 09:04 AM

[eluser]nmweb[/eluser]
There is a perfect working library to handle such matters in the wiki. MPTT, or MPTTree or something is it's name. It handles all the lft, rgt stuff + scope so you can have multiple trees in one table. It can even do ORM for you.

Adjacency lists might bring about problems with performance but proper caching or just loading the entire table and have php handle the parents/childs you can cut down on the queries.

Messages In This Thread

Hieratic Category Query - by El Forum - 03-14-2008, 04:12 AM

Hieratic Category Query - by El Forum - 03-14-2008, 06:53 AM

Hieratic Category Query - by El Forum - 03-14-2008, 08:11 AM

Hieratic Category Query - by El Forum - 03-14-2008, 05:23 PM

Hieratic Category Query - by El Forum - 03-15-2008, 12:58 AM

Hieratic Category Query - by El Forum - 03-15-2008, 12:59 AM

Hieratic Category Query - by El Forum - 03-15-2008, 01:16 AM

Hieratic Category Query - by El Forum - 03-15-2008, 09:04 AM

Hieratic Category Query - by El Forum - 03-15-2008, 04:01 PM

Hieratic Category Query - by El Forum - 03-15-2008, 05:19 PM

Hieratic Category Query - by El Forum - 03-15-2008, 06:18 PM

Hieratic Category Query - by El Forum - 03-15-2008, 06:50 PM

Hieratic Category Query - by El Forum - 03-15-2008, 07:18 PM

Hieratic Category Query - by El Forum - 03-15-2008, 09:19 PM