W/o looking at SQL it is impossible to say what the problem is. Perhaps, it is using joins for the opposite direction. I am not saying it takes that long but I can't say it isn't neither. It would also help if you could compare the SQL from 3.0.8 and 3.2.3 and let us know how long it took in 3.0.8.
<a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3827858#3827858">View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3827858>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user