If the performance is 100 times slower the problem is you are not using transactions correctly. The data that is read ahead must be accessed in the same transaction it was loaded, it is not used it is thrown away at the end of the transaction. If you have lots of little transaction you read lots of data and throw it away. This can result in O(n^2) performance.
Use a single transaction. -dain Bill Burke wrote: > AFAIK, there is no query caching done at all in JBoss except for > findByPrimaryKey. Well...at least with CMP 1.1, with CMP 2.0 there may be > some query caching going on, but I'm guessing not. Dain would be the best > to answer that. > > Also, I remember someplace that PreparedStatement caches were removed. > Maybe this had/has an effect. But again, probably not. > > >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED]]On Behalf Of Jos Henrique >>Varanda >>Sent: Thursday, June 06, 2002 12:45 PM >>To: [EMAIL PROTECTED] >>Subject: [JBoss-user] Entity Bean Cache performance issue in Jboss3.0.0 >> >> >>Hello, >> >>I was using jboss-3.0.0rc3 and performance was not an >>issue. Now I've installed jboss-3.0.0 and there is a >>serious performance problem in that version. >> >>I have 1500 entities into my DB and in a finder method >>I look for them all. In RC3 the first time I execute >>the finder is 2 times slower than the next ones, when, >>I suppose, cache takes place. Now, in jboss-3.0.0, the >>same finder executes 100 times or more slower than RC3 >>in the first time I execute it and just a second >>slower in the next ones, when cache assumes.Is this a >>bug in cache initialization? Anybody else noted this? >> >>I checked the log file and the sql generated statements >>and they look like the same in both versions. My >>machine CPU gets a peek during the first finder call, >>indicating that there is a lot of work being done. >>Why is there this significative slower performance between >>versions? >>Can anybody help me with this issue? >> >>Thanks, >>jhvaranda >> >> >>_________________________________________________________________ >>Una-se ao maior serviço de email do mundo: o MSN Hotmail. >>http://www.hotmail.com >> >> >>_______________________________________________________________ >> >>Don't miss the 2002 Sprint PCS Application Developer's Conference >>August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm >> >>_______________________________________________ >>JBoss-user mailing list >>[EMAIL PROTECTED] >>https://lists.sourceforge.net/lists/listinfo/jboss-user >> > > > _______________________________________________________________ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user