Hi Shiva, I suggest you to have a look at our performance test framework (PTF) under src/tests/ptf/jdo. PTF demonstrats different access situations and loading strategies on a tree of objects with 1:n relations. Especially you may want to look for the strategy I call OID loading as this can improve your load performance by a factor of 10 depending on your object hierarchy.
Having said that PTF is only included in the source distribution of castor and is configured to run against a mysql database. The result of some runs of PTF on a 2GHz PC with different refactorings are also included. For the latest results have a look at: src/tests/ptf/jdo/rel1toN/results-tx-poly.txt. Regards Ralf Castor JDO, committer Shiva P. Kodityala schrieb: > Yes, I read that. > > I have little complex mapping: > > TableAClass has some fields and array of TableBClass objects; TableBClass has > some fields and array of TableCClass objects. > > Trying to query TableAClass objects (Indirectly getting TableBClass and > TableCClass objects underneath). > > I don't know whether I am doing lazy loading or something. How do I set it? > > Thanks > > > > > > > -----Original Message----- > From: Werner Guttmann [mailto:[EMAIL PROTECTED] > Sent: Friday, December 09, 2005 8:51 AM > To: [email protected] > Subject: RE: [castor-user] Query Performance > > > In general, can I assume that you have read > > http://castor.codehaus.org/jdo-best-practice.html > > In particular, what kind of relationships to you use ? Are you using > lazy loading ? Etc. > > Werner > > > > wg> -----Original Message----- > wg> From: Shiva P. Kodityala [mailto:[EMAIL PROTECTED] > wg> Sent: Friday, December 09, 2005 5:39 PM > wg> To: [email protected] > wg> Subject: [castor-user] Query Performance > wg> > wg> > wg> A query results in tens of thousands of rows. How should I > wg> improve the performance? Making use of constant > wg> Database.ReadOnly; Using castor release 0.9.9. Is there > wg> any way to fetch results in bulk instead of one row by another? > wg> > wg> Thanks > wg> > wg> ------------------------------------------------- > wg> If you wish to unsubscribe from this list, please send an > wg> empty message to the following address: > wg> > wg> [EMAIL PROTECTED] > wg> ------------------------------------------------- > wg> > wg> > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- -- Syscon Ingenieurbüro für Meß- und Datentechnik GmbH Ralf Joachim Raiffeisenstraße 11 D-72127 Kusterdingen Germany Tel. +49 7071 3690 52 Mobil: +49 173 9630135 Fax +49 7071 3690 98 Email: [EMAIL PROTECTED] Web: www.syscon-world.de ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
