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: Open Resolution: None Priority: 5 Submitted By: Peter Luttrell (objec) Assigned to: Nobody/Anonymous (nobody) 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. ---------------------------------------------------------------------- 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
