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

Collapse
Posted by Jun Yamog on
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
Posted by Jun Yamog on
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