* Odd Rune Bekkum > Hi! > I'm working on the same project as Jon. > > Digging into it a bit more I've found the following: > If we do a findAll on a table containing 252 rows we get 252 SQL calls, > the first one containg 252 ors, the next one 251, then 250.. down to 1. > So from what I understand JBoss first gets all the unique ids, then doing > all the or selects with one less or each time. > To run this query takes a over 3 minutes. > > Have we set up something wrong or is due to the translation from ejb-ql to > JBoss SQL.
Jeg synes jeg ble kvitt disse når jeg la inn følgende kode i bønnen: * @jboss:read-ahead strategy="none" page-size="0" > > Any help appreciated. You're welcome... -- Jon Haugsand, <[EMAIL PROTECTED]> Norges Bank, <http://www.norges-bank.no> ------------------------------------------------------- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0004en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
