> Sorry lets put that in context, need to eliminate N+1 query problem first.
> Reduce trips to the database is #1. Then make the trips more efficient.
yes, 2 queries should be enough assuming that one bean's data can be
contained within one row.
query 1: is the finder query that returns the primary key objects.
query 2: is the retrieve query that returns the data for the actual entity
beans.
if query 2 is constructed in such a way that
a) select ...all data that needs to be collected... from table
b) where ...same where clause as the find query...AND (additional joins if
needed)
as you can see. since query 1 and query 2 should have similar where clauses,
there is no need to execute "select ...data... from table where key = ?" N
number of times.
does this makes sense to you, so in this case each findXXX:Collection would
only require two queries.
Filip
~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
