hi alexey,
crit.addPrefetchedRelationship("parameters");
"parameters" is the name of the relationship defined by a collection-descriptor in the repository, the name may differ in your sample.
could you please provide the sample-code and the p6spy generated with and withou prefetching.
thanks
jakob
Alexey Drougov wrote:
Hi Jakob,
----- Original Message -----
From: "Jakob Braeuchi" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 7:35 PM
Subject: Re: why 1:n relationship produces 2*(n+1) queries ?
hi alexey,
afaik prefetching work ok for 1:n relationships. what kind of problem did
you have with it ?
crit.addPrefetchedRelationship("parameters"); makes no visible changes in
program execution,
looks like silently ignored
Does every query, that appear in log file realy executed by database or
not
you'd better use p6spy to log sql-statements.
P6Spy helped :)
it shows only "select ..." and additional "select count(*) ..."
I use OJB version 0.9.8 of date 2002-12-21 15:00 compiled from
jakarta-ojb-0.9.8-src.tgz
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
