Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
From: "Amit Rana" <rana@solis.jp>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
Subject: RE: Performance problems
Date: Thu, 27 Nov 2003 16:25:04 +0900
Message-ID: <006701c3b4b7$95b38190$0e01a8c0@RANAS8200>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Importance: Normal
In-Reply-To: <3FC59C01.9080605@joshholtzman.com>

> 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:josh@joshholtzman.com]
> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org