openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brill Pappin" <br...@pappin.ca>
Subject RE: Slow JPA
Date Fri, 04 Apr 2008 23:30:34 GMT
 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:kwsutter@gmail.com] 
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 <brill@pappin.ca> 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 <soberdrunk22@hotmail.com>
> 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:soberdrunk22@hotmail.com]  > 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.
> >
> >
>


Mime
View raw message