Forum OpenACS Development: using tree_ancestor_p ... good or bad?

Collapse
1: using tree_ancestor_p ... good or bad?
Posted by Jun Yamog on 07/31/03 06:32 PM
Hi,

I used tree_ancestor_p several months ago for bcms.  I am revisting the procs.  So I figured to change if needed.

Basically its used in the tree_X calls.  like tree_folders call which give you the subfolders.  I think you can go about using tree_ancestor_p or using some sort of between query.

Is tree_ancestor_p a good plsql?  It makes the query looks cleaner and more readable at first glance.  Performance seems to be ok.  What do you guys think?

Collapse
2: Re: using tree_ancestor_p ... good or bad? (response to 1)
Posted by Jun Yamog on 07/31/03 07:21 PM
Hi,

Jeff Davis told me on IRC that between is faster.  I tried it with a crude set of rows.  Jeff is right, its a bit faster.  Since I don't significantly sacrifice the readability.  As the tcl proc is what is mean to be used.  I will use the between query.  That should affect all callers of tree_folders