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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
