[MYSQL] A recursive query?

[MYSQL] A recursive query?

El Forum
Guest

#12

03-14-2009, 05:26 AM

[eluser]Colin Williams[/eluser]
The benefit of MPTT is more optimal queries. The downside is all the code you need to keep it managed. With parent_ids, you have two options: Provide a $depth option and recur through that depth, which will start to rack up queries. Or, grab the entire table in one query and then filter through it with PHP code. I would toy with each option (maybe have two functions in your model that do each) and just test it out.

Messages In This Thread

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 04:28 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 04:57 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:01 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:10 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:13 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:19 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:30 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 09:11 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 10:09 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 10:15 AM

[MYSQL] A recursive query? - by El Forum - 03-14-2009, 02:25 AM

[MYSQL] A recursive query? - by El Forum - 03-14-2009, 05:26 AM