Bugs item #615553, was opened at 2002-09-27 11:00 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=615553&group_id=22866
Category: JBossCMP Group: v3.1 >Status: Closed >Resolution: Invalid Priority: 9 Submitted By: Peter Luttrell (objec) Assigned to: Dain Sundstrom (dsundstrom) Summary: Bean Load generates way more SQL Initial Comment: I'm using most of the default jboss settings. I wasn't able to change the read-ahead settings (see other bug, which is now fixed). I have a finder method that returns in this case 1106 entity beans. Then i iterate through the collection and grab most of the data. This takes an enormous amount of time. Some 900,000ms in one particular test. I looked at the sql jboss generated in the server.log file and beleive that there is some looping error because it is generating way too much sql. According to my understanding the default readahead settings will cause jboss to construct a sql statement with 255 ORs, hense reading the 1106 rows in 5 different sql statements. But JBoss is actually creating 1106 sql statements with varring amounts of ORs. Some times JBoss executes sql statements with the same large number 255, i think. Other times it does a series of 255, 254, 253....1. It's actually a pretty waterfall effect. I could post my log file, but it's like 5mbs. Dain, please email me if you'd like the log file sent directly to you. ---------------------------------------------------------------------- >Comment By: Dain Sundstrom (dsundstrom) Date: 2002-09-27 11:12 Message: Logged In: YES user_id=251431 Optimized loading is overed in the JBossCMP documentation chapter 6. Look for the O(n^2) section. The problem is you are not using a transaction. BTW, changing the priority does not get your bug fixed any faster. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=615553&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development