Adrian Crum wrote: > I have a client who has asked me to look into the performance problem with > the balanceInventoryItems service. I see from the commit logs that it has > been a problem for others too - David mentions it in the rev 576793 commit > log. > > I'd like to get this fixed in the trunk. If anyone has any ideas on ways to > improve it, please let me know. I have some ideas of my own. Maybe together > we can get this fixed.
Hmm, outer query, loop over results, inner getRelated, second nested inner loop, and none of this cached. Yup, perfect candidate for a View. ps: Hint, a View can contain nested Views. IE, a member-entity can point to a view itself.
