We don't have time to run it through YourKit and try to trace the issues, but my partner and I feel strongly that if we want something good, we can pitch in to help get it fixed. To that end, we'll attempt to provide some sample code that can reproduce the specific problem we were having.
Not sure exactly when, but we'll drop in an issue in JIRA when we get to it. - Brill Pappin -----Original Message----- From: Kevin Sutter [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2008 11:22 AM To: users@openjpa.apache.org Subject: Re: Slow JPA Brill and others, Thanks for the feedback. As one of the notes indicated, any orm framework is going to be slower than straight JDBC, but it shouldn't be significant. Understanding and controlling what entities get fetched (lazy vs eager) is an excellent first step. It sounds like you are already investigating that. If the standard JPA lazy vs eager annotations are not granular enough for your usage, then you may want to take a look at OpenJPA's FetchPlans and FetchGroups ( http://openjpa.apache.org/docs/latest/manual/manual.html#ref_guide_fetch). We are constantly looking at the performance of OpenJPA and attempting to improve it. One of the changes that Patrick recently introduced was removing the JDK 4 requirement for some of our "kernel" modules. Surprisingly, this "little change" helped the performance of our benchmarks. This was introduced in the 1.1.0 branch of OpenJPA. If you can provide more details on your specific scenarios (database, sql, entity definitions and interactions, etc), maybe we can help pinpoint the areas of concern. Our goal is to have OpenJPA be the best performing JPA implementation available, so we would appreciate the feedback. Thanks, Kevin On Fri, Apr 4, 2008 at 9:55 AM, Brill Pappin <[EMAIL PROTECTED]> wrote: > We were using 1.0 in this project, but its showing up in another > project using 1.1. > > I really *want* to use ojpa but I don't have time to mess around and > the problem is significant. > There seem to be other inefficiencies as well that don't seem to need > to be there. > > Not sure what we're going to do about it though, all the ORM > frameworks are going through some sort of growing pain at the moment > and I can't say I'm happy with any of them. > > - Brill Pappin > > On Fri, Apr 4, 2008 at 10:44 AM, Patrick T <[EMAIL PROTECTED]> > wrote: > > > > My issue is even just fetching the entities. Despite of changing > > relationships to LAZY fetch, I find that querying the DB takes a > > really > long > > time. I have experienced the commit issue as well,but I've worked > around > > that by being careful on what I cascade through different entities. > > > > > > > > Brill Pappin wrote: > > > > > > As a rule you can expect *any* orm framework to be slower than > > simple > JDBC, > there is simply more to do... What you gain from > > it is ease of > maintenance > > > and implementation which will save you time later (often a lot of > time). > > > As with anything, you need to weigh the benefits of any solution > > over > another but in my experience most applications don't require > > such > high > > > throughput that anyone would notice a couple of milliseconds > > saved > here > > > and > > > there... Of course it'll depend on what your doing :) > > > > However... > > > > > > I've just been doing some work tonight, and am finding that > > begin() > -> > > > commit() transactions take longer and longer (in my case I have a > very > > > large > > > update that is broken down into chunks). I haven't traced the > > problem > yet > > > and it may be configuration related, however the time grows > exponentially. > > > Does that sound like the same problem you are having? > > > > > > - Brill > > > > > > -----Original Message----- > > > From: Patrick T [mailto:[EMAIL PROTECTED] > Sent: > > Friday, March 28, 2008 3:55 PM > To: users@openjpa.apache.org > > > Subject: Slow JPA > > > Hello Everyone, > > I'm just wondering > > if anyone else is finding JPA slower than simple > jdbc > > > implementations. I have tried setting up some of the attributes > > to > Lazy > > > fetch and I still find it to be extremely slow. This is causing > > my > web > > > pages > > > to load in the upwards of 10 seconds. I have tried running the > PCEnhancer > > > and still takes a long time to fetch data. Does anyone have any > > > suggestions > to speed it up? Thanks. > > > > > > Patrick > > > -- > > > View this message in context: > > > http://www.nabble.com/Slow-JPA-tp16360845p16360845.html > > > Sent from the OpenJPA Users mailing list archive at Nabble.com. > > > > > > > > > > > > > -- > > View this message in context: > http://www.nabble.com/Slow-JPA-tp16360845p16491755.html > > Sent from the OpenJPA Users mailing list archive at Nabble.com. > > > > >
