Prefetched relationships /performance

[Joerg Lensing <in...@softcon-lensing.de>]

hi all,

when querying object "partnerPO"[100 tablerows] with a collection of  
"addresses" [each partner has ONE address now, later more]
the query needs 8 to 10 seconds, depending on the query I use. With 
dynamic proxy, the query needs 8 seconds, with using
prefetched relationships (without the proxy), the query needs 12 seconds.

For pref.rel. I use
        QueryByCriteria query = new QueryByCriteria(PartnerPO.class, null);
        query.addPrefetchedRelationship("allAddresses");
        Collection allPartner = broker.getCollectionByQuery(query);

Is this the expected time for this configuration?

joerg


OJB rc4
MySQL,
sdk 1.4.0
768 RAM
2,5 Ghz P4


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