[JBoss-dev] [ jboss-Bugs-615553 ] Bean Load generates way more SQL
Bugs item #615553, was opened at 2002-09-27 12:00 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=615553group_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, 2531. 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: C. Lamont Gilbert (dnoyeb) Date: 2002-12-19 01:44 Message: Logged In: YES user_id=280374 I am experiencing the same thing in 3.0.4 but appearantly you are saying this is correct behavior. I need the documentation. will purchase... -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-09-27 12: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=detailatid=376685aid=615553group_id=22866 --- This SF.NET email is sponsored by: Order your Holiday Geek Presents Now! Green Lasers, Hip Geek T-Shirts, Remote Control Tanks, Caffeinated Soap, MP3 Players, XBox Games, Flying Saucers, WebCams, Smart Putty. T H I N K G E E K . C O M http://www.thinkgeek.com/sf/ ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-615553 ] Bean Load generates way more SQL
Bugs item #615553, was opened at 2002-09-27 11:00 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=615553group_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, 2531. 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=detailatid=376685aid=615553group_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
[JBoss-dev] [ jboss-Bugs-615553 ] Bean Load generates way more SQL
Bugs item #615553, was opened at 2002-09-27 11:00 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=615553group_id=22866 Category: JBossCMP Group: v3.1 Status: Open Resolution: None 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, 2531. 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=detailatid=376685aid=615553group_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
[JBoss-dev] [ jboss-Bugs-615553 ] Bean Load generates way more SQL
Bugs item #615553, was opened at 2002-09-27 11:00 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=615553group_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, 2531. 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=detailatid=376685aid=615553group_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
