I have an EJB-QL query which returns a lot of records. If I execute this using the default config (on-load), I get a OutOfMemoryException. This sounds logical as JBoss is trying to load all my entity beans in memory/cache (I am using commit option A if that matters).
Just using on-load and changing the page-size only changes the number of queries which are generated (sounds logical). The easy solution if to change the read-ahead strategy to on-find. However, this completely kills performance and suddenly causes related records to be (completely) loaded as well. The "none" strategy seems to be the best current option, eben if this generates separate SQL wueries to the the link field for external links. Would it not be possible to have some kind of variant of on-load/page-size which does not immediately load all results, but loads the data in chunks (which basically is what I thought on-load is supposed to do). Joachim View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3829937#3829937 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3829937 ------------------------------------------------------- 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
