> >Try use the 2 query approach as described below rather than recursively query >the sub(sub) - categories. querying recursively is a performance killer espessially >when insrels are involved. We speeded up our app's initialisation drastically (from >10 secs to 0.2) when we changed our code to the two query approach although >intuitively one would prefer the more elegant recursive approach.
michiel's tree tag is a bit better then
<mm:related>
<mm:related>
<mm:related>
</mm:related>
</mm:related>
</mm:related>
because it makes 1 query per level
so it will create 3 queries for the above
related
related/related
related/related/related
This is not very bad but when you get more levels it might be to much
<<winmail.dat>>
