> I'm wondering what's going on when I ask the JSP to > account.getAssignments(). Is the JSP hitting the database in order to > instantiate the account's assignments? Yes, I remember reading it somewhere in the docs. Your call for Assignments results in a DB query. Check the logs, it will tell you whats happening.
HTH Amit. > -----Original Message----- > From: Josh Holtzman [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 27, 2003 3:39 PM > To: Apache Torque Users List > Subject: Performance problems > > I'm using torque in a webapp, and I'm seeing really slow performance > when I try to get data from "nested" objects. Here's what I mean: > > I have a torque object named Account. An account can have several > Assignments, which is another torque object. An assignment can have > Jobs (yup -- another torque object) and a Job can have a Category (yet > another torque object). Due to the amount of data stored in each of > these, they must be separate objects (I'm trying to avoid eliciting the > obvious solution "put all of that info in one object" suggestion). > > I grab a list of accounts in my servlet with a doSelect(criteria) and > send them to a JSP to be displayed (I'm using struts, but that's beside > the point). If I ask the JSP to just display info in the Account > object, everything runs quickly. If I ask the JSP to get the Account's > Assignments and display info from the Assignments, it slows down a bit. > Once I ask for Job or category info, it grinds to a crawl. > > I'm wondering what's going on when I ask the JSP to > account.getAssignments(). Is the JSP hitting the database in order to > instantiate the account's assignments? I would think that when I > instantiated the Account, all of its own internal objects (the > assignments, the jobs, the categories) would also be instantiated. So > why then the huge performance hit? > > I know that I am missing something here, so please, all of you Torque > gurus, let me know where young grasshopper has strayed from the path. > And if I need to provide more details (code, etc), I can do that too. > > Thanks so much, > Josh > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
