Hi vikram, I'm not in the JBoss gurus confidence, but it seems that the implementation of the CMP engine is just like this. I think the fisrt query is generated by the CMR collection handler (just querying id's) and the second by the persistence engine which collects all the CMP fields for each entity. The whole optimization here is to factorize all the entity beans in a single query using (id=?) or (id=?) and so on. But the CMP engine seems not to be aware of the originated CMR.
Actually, the best way (means the most performant) to collect "entities in relation with" is to write your own finder with the "one entity" id as parameter. If we have some chance, the JBoss CMP guru (Alex) will post his advice here. Pascal View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834331#3834331 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834331 ------------------------------------------------------- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
