Thanks Adam! That was one of the things I was considering. ;-) -Adrian
--- On Fri, 10/31/08, Adam Heath <[EMAIL PROTECTED]> wrote: > From: Adam Heath <[EMAIL PROTECTED]> > Subject: Re: Performance problem with balanceInventoryItems service > To: [email protected] > Date: Friday, October 31, 2008, 7:31 PM > 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.
