Have been having similar issues, and my 'psuedo-hack' tests show similar results to Georg, so thank you Georg for pointing out that the database lookups are not the problem, but the object conversion piece.
I don't wish to sell other products, but for a reference, has anyone seen a difference if they switch to another CMP Persistance engine such as Gemstone? I tried their eval on Jboss3.0.3, but I couldn't get it to work in my environment. Would be nice to know as a reference if solving the entity-bean performance is clearly tied to CMP/Persistance, and also have available proven workarounds for people that have short timelines (yeah, I'm one of the many :-P). Please do not debate about commercial versus open-source methodology, just looking for solution to immediate business problems and methods to identify areas of improvements :-). Oh, and LIMIT/OFFSET's would be awesome!!! -D --__--__-- Message: 1 Date: Wed, 30 Oct 2002 14:14:06 -0600 From: Dain Sundstrom <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Entity Bean Performance Tuning Help Reply-To: [EMAIL PROTECTED] Georg Schmid wrote: > It seems that my (and, at least to some degree, Peter's) specific > problem is misunderstood. Sorry, that happens all the time on the lists.... > In my case: the problem is NOT getting the data from the database fast > (the finders execute fast enough). > I think Jboss does not have a problem there, but that's my guess, as I > do not have personal experience > with other app servers. > > The performance is lost, when I try to convert the a collection of local > entity bean references > into a collection of value objects. None of the previous posts (except > Peter's) touches upon this subject. > > I want to understand and, if possible, solve this 'value object > conversion speed' problem: > <snip/> > The for-loop should be able to convert 1000 local entity bean references > per second or better for simple entity beans. Can you send me this code so I can test with a profiler? I want to know where all the time is spend. What version of JBoss are you using? > I am not interested in any CMP vs non-CMP debate. TSS may be a better > place for this. Agreed. > It would be convenient, if the size of the result sets, that can be > handled using CMP, coincides with the number of rows > you should/could reasonably display in a dialog or page in your > (web-based) GUI. This would remove the need to switch > to raw JDBC, when doing the CMP equivalent of plain vanilla (for > instance) "select * from BeanTable where lastUpdate >= '10/20/2002'" > queries. That's all I hope for. You lost me. JBoss 4.0 will have support the LIMIT someNumber OFFSET someNumber syntax. Is that what you are talking about. I would like to be able to support Date literals, but I don't want to get too far in front of the spec. Does anyone know where I can find the ANSI SQL spec on date literals? (I'm not interested in how Oracle does this... I want to know the standard). > CMP will keep getting more powerful over time. Using it is 'Making the > trend work for you'. Yep... keep the suggestions coming, and we can make this the best persistence engine period. -dain ------------------------------------------------------- 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
