Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Shubbis
relation, therefor we have to tell these //wearhouses this storargecategories is on of the wearhouse's storagecategories. for (Wearhouse wearhouse : wearhouses) wearhouse.addStorageCategories(this); } } -- View this message in context: htt

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Kevin Sutter
ng storageCategoryName) { >this.storageCategoryName = storageCategoryName; >} > >public List getWearhouses() { > return wearhouses; > } > > public void setWearhouses(List wearhouses) { >this.wearhouses =

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Shubbis
public Integer getStoragecategoryNr() { >>return this.storagecategoryNr; >>} >> >>public void setStoragecategoryNr(Integer storagecategoryNr) { >> this.storagecategoryNr = storagecategoryNr; >>} >> >>public String getStorageCategoryN

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Kevin Sutter
uot;, > >> cascade={CascadeType.PERSIST}) > >> private List wearhouses; > >> > >>public Storagecategory() { > >>} > >> > >>public Storagecategory(String storageCategoryName) { > >>

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Jeremy Bauer
torageCategoryName; > >> > >>@ManyToMany(mappedBy="storageCategories", > >> cascade={CascadeType.PERSIST}) > >>private List wearhouses; > >> > >> public Storagecategory() { > >>} > >> > >>publi

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Shubbis
port java.util.*; >> >> >> >> import javax.persistence.*; >> >> >> >> @Entity >> >> public class Storagecategory { >> >> >> >>@Id >> >>@GeneratedValue(strategy = GenerationType.IDENTITY) >>

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Shubbis
;> >> >>} >> >> >> >> } >> >> >> >> >> >> >> >> package project.common.model; >> >> >> >> import java.util.*; >> >> >> >> import javax.persistence.*; >>

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Jeremy Bauer
return storageCategories; > >> >>} > >> >> > >> >>public void addStorageCategories(Storagecategory > >> storagecategory) > >> >> { > >> >> if(storageCategories == null) > >> &g

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Pinaki Poddar
http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2470215.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Rick Curtis
> > PS: "Aristotle maintained that women have fewer teeth than men; although > he was twice married, it never occurred to him to verify this statement by > examining his wives' mouths." -- > The Impact of Science on Society, 1952 - Bertrand Russell > &g

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
;> [1] >> http://openjpa.apache.org/faq.html#FAQ-HowdoIenableconnectionpoolinginOpenJPA%253F >> >> Regards -- >> >> >> PS: "Aristotle maintained that women have fewer teeth than men; although >> he was twice married, it never occurred to him to verify this statement >> by examining his wives' mouths." -- >> The Impact of Science on Society, 1952 - Bertrand Russell >> >> > > -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2490426.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
S: "Aristotle maintained that women have fewer teeth than men; although > he was twice married, it never occurred to him to verify this statement by > examining his wives' mouths." -- > The Impact of Science on Society, 1952 - Bertrand Russell > > -- View this m

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Pinaki Poddar
I do not find anything obvious in the tests that can cause the slowdown. Now the usual suspect: Have you enhanced Storeage/WeraHouse classes at build-time? -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
m/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2490593.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
. See if maybe its my enhancing thats the problem. Shubbis -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2491667.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Michael Dick
> > Now the usual suspect: Have you enhanced Storeage/WeraHouse classes at > > build-time? > > > > > > Maybe someone could post an example of their build.xml file so that i could > try it. See if maybe its my enhancing thats the problem. > > Shubbis > -- >

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Pinaki Poddar
> > Pinaki Poddar wrote: >> >> I do not find anything obvious in the tests that can cause the slowdown. >> Now the usual suspect: Have you enhanced Storeage/WeraHouse classes at >> build-time? >> >> > > > Shubbis > -- View this message in c

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Rick Curtis
if maybe its my enhancing thats the problem. > > Shubbis > -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2492327.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
twice > perhaps will confirm -- because second time it will say: 'class X is > already persistence-capable. Ignoring...' etc. > > [1] http://people.apache.org/~ppoddar/eclipse/ > > -- View this message in context: http://n2.nabble.com/Slow-performance-with-Ope

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Paul Copeland
What is different abut your laptop at home vs. multiple computers at work? Are they all connected to the same network? On 3/17/2009 11:30 AM, Shubbis wrote: Ok, I still dont know what the problem is, but it seems like its not OpenJPA's fault (i think). I just took the whole project home with m

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
gt;> If you are an Eclipse IDE user, you can try a plugin [1] that keeps >>> your >>> classes enhanced always. Or you may be better of with Ant builds as Mike >>> had provided. >>> >>> In either case, Enhancer displays log messages and running

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Pinaki Poddar
gt; perhaps will confirm -- because second time it will say: 'class X is >> already persistence-capable. Ignoring...' etc. >> >> [1] http://people.apache.org/~ppoddar/eclipse/ >> >> > > -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2493300.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-18 Thread Shubbis
ancer displays log messages and running it twice >>> perhaps will confirm -- because second time it will say: 'class X is >>> already persistence-capable. Ignoring...' etc. >>> >>> [1] http://people.apache.org/~ppoddar/eclipse/ >>> >>> >>> >> >> >> >> > > > -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2496032.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-18 Thread Georgi Naplatanov
Hello Shubbis. Did you check generated SQL ? OpenJPA has property about how to perform joins. My be with traditional join syntax performance will be better. Best regards Georgi Shubbis wrote: > Todays update, for those who are interested. ;) > > I've uninstalled all JRE, JDK, SDK etc all j

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-18 Thread Shubbis
And a link to the complete project, with all jar files etc in the lib folder. http://files.sharetoad.com/?id=f89de9caa6 OpenJPA project -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2496066.html Sent

RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-18 Thread Nitish Kumar
ys log messages and running it twice > perhaps will confirm -- because second time it will say: 'class X is > already persistence-capable. Ignoring...' etc. > > [1] http://people.apache.org/~ppoddar/eclipse/ > > -- View this message in context: http://n2.nabble.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-18 Thread Kevin Sutter
as a dependency on commons-io but works great. > > Thanks and Regards, > Nitish Kumar > > -Original Message- > From: Shubbis [mailto:marius.jo...@broadpark.no] > Sent: Wednesday, March 18, 2009 12:01 AM > To: users@openjpa.apache.org > Subject: Re: Slow performance wit

RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-18 Thread Pinaki Poddar
> PS: I still could not make the enhancer work with ANT What was the problem? -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2498707.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Shubbis
ormation... I just heard that EclipseLink > runs with a data cache enabled by default, while OpenJPA and Hibernate do > not. Although this setting may not get us completely out of this > ManyToMany > performance hole, it is something to be aware of as these performance > benc

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Shubbis
gt; could try it. See if maybe its my >>>>>> enhancing thats the problem. >>>>>> >>>>> If you are an Eclipse IDE user, you can try a plugin [1] that keeps >>>>> your >>>>> classes enhanced always. Or you may be better of with Ant builds as >>>>> Mike >>>>> had provided. >>>>> >>>>> In either case, Enhancer displays log messages and running it twice >>>>> perhaps will confirm -- because second time it will say: 'class X is >>>>> already persistence-capable. Ignoring...' etc. >>>>> >>>>> [1] http://people.apache.org/~ppoddar/eclipse/ >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >> > > > -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2501693.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Nitish Kumar
comparison. Thanks and Regards, Nitish Kumar -Original Message- From: Kevin Sutter [mailto:kwsut...@gmail.com] Sent: Wednesday, March 18, 2009 10:17 PM To: users@openjpa.apache.org Subject: Re: Slow performance with OpenJPA when selecting from a ManyToMany relation. One other

RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Nitish Kumar
Although this setting may not get us completely out of this > ManyToMany > performance hole, it is something to be aware of as these performance > benchmarks are done... > -- View this message in context: http://n2.nabble.com/Slow-performance-with-Open

RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Shubbis
someone from Open JPA team looks into the issue. > > Thanks and Regards, > Nitish Kumar > -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2503084.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Kevin Sutter
pool and it works fine. That should get you > > moving as of now, till someone from Open JPA team looks into the issue. > > > > Thanks and Regards, > > Nitish Kumar > > > > -- > View this message in context: > http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2503084.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. > >

RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Pinaki Poddar
ld post an example of their build.xml file so that > i >> >> could try it. See if maybe its my >> >> enhancing thats the problem. >> > >> > If you are an Eclipse IDE user, you can try a plugin [1] that > keeps >> your >> > classes

RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Nitish Kumar
oddar [mailto:ppod...@apache.org] Sent: Thursday, March 19, 2009 8:46 PM To: users@openjpa.apache.org Subject: RE: Slow performance with OpenJPA when selecting from a ManyToMany relation. > Once you configure Open Jpa with a connection pool as mentioned here the numbers drop drastically. That

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Paul Copeland
. Thanks and Regards, Nitish Kumar -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2503084.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-20 Thread Michael Dick
> >>> Nitish Kumar wrote: >>> >>> >>>> Hi subbis, >>>> If I let the iteration loop over 5000, I get that exception, It >>>> seems (I am not sure) openjpa is creating a new connection and after a >>>> while mysql runs out of connection. I tried the same code and iteration >>>> loop with a connection pool and it works fine. That should get you >>>> moving as of now, till someone from Open JPA team looks into the issue. >>>> >>>> Thanks and Regards, >>>> Nitish Kumar >>>> >>>> >>>> >>> -- >>> View this message in context: >>> >>> http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2503084.html >>> Sent from the OpenJPA Users mailing list archive at Nabble.com. >>> >>> >>> >>> >> >> >> > >

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-20 Thread Michael Dick
>>> >>>> The results are sadly not that great. Yes, it's faster and it doesn't >>>> run >>>> out of connections like before, BUT it's still 3, yes, -three- times >>>> slower >>>> than Hibernate, EclipseLink, iBatis and regular JDBC when persisting >>>> entities with many relations. >>>> >>>> Clearly this is not the kind of results I was hoping for and I'm quite >>>> perplexed as to what to do. >>>> >>>> Shubbis >>>> >>>> >>>> Nitish Kumar wrote: >>>> >>>> >>>>> Hi subbis, >>>>> If I let the iteration loop over 5000, I get that exception, It >>>>> seems (I am not sure) openjpa is creating a new connection and after a >>>>> while mysql runs out of connection. I tried the same code and iteration >>>>> loop with a connection pool and it works fine. That should get you >>>>> moving as of now, till someone from Open JPA team looks into the issue. >>>>> >>>>> Thanks and Regards, >>>>> Nitish Kumar >>>>> >>>>> >>>>> >>>> -- >>>> View this message in context: >>>> >>>> http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2503084.html >>>> Sent from the OpenJPA Users mailing list archive at Nabble.com. >>>> >>>> >>>> >>>> >>> >>> >>> >> >> >

RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-20 Thread Nitish Kumar
hold the connection always. Thanks and Regards, Nitish Kumar -Original Message- From: Michael Dick [mailto:michael.d.d...@gmail.com] Sent: Sat 3/21/2009 1:55 AM To: users@openjpa.apache.org Subject: Re: Slow performance with OpenJPA when selecting from a ManyToMany relation. Hi all

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-21 Thread Michael Dick
age- > From: Michael Dick [mailto:michael.d.d...@gmail.com] > Sent: Sat 3/21/2009 1:55 AM > To: users@openjpa.apache.org > Subject: Re: Slow performance with OpenJPA when selecting from a ManyToMany > relation. > > Hi all, > > As Paul pointed out privately I didn't i

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-21 Thread Paul Copeland
k [mailto:michael.d.d...@gmail.com] Sent: Sat 3/21/2009 1:55 AM To: users@openjpa.apache.org Subject: Re: Slow performance with OpenJPA when selecting from a ManyToMany relation. Hi all, As Paul pointed out privately I didn't indicate which versions of OpenJPA I was using. I've been t

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-21 Thread Paul Copeland
. Thanks and Regards, Nitish Kumar -Original Message- From: Michael Dick [mailto:michael.d.d...@gmail.com] Sent: Sat 3/21/2009 1:55 AM To: users@openjpa.apache.org Subject: Re: Slow performance with OpenJPA when selecting from a ManyToMany relation. Hi all, As Paul pointed out privately

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-22 Thread Shubbis
haven't been able to >>>> dig >>>> into your benchmark to the extent that we would like. If we can verify >>>> that >>>> the enhancement processing is happening, that would be good input. >>>> Thanks >>>> for your patience. W

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-22 Thread Shubbis
gt; > Hi subbis, >> > If I let the iteration loop over 5000, I get that exception, It >> > seems (I am not sure) openjpa is creating a new connection and after a >> > while mysql runs out of connection. I tried the same code and iteration >> > loop with

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-23 Thread Michael Dick
gt;>>> greatly > >>>> appreciate your efforts. The last time one of these comparisons was > >>>> posted, > >>>> the benchmark code and process was flawed. So, I am pleased to see > the > >>>> efforts associated with this exercise

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-25 Thread Shubbis
t;> > >>>> It really seems that you are trying to do a fair comparison, and I > >>>> greatly > >>>> appreciate your efforts. The last time one of these comparisons was > >>>> posted, > >>>> the benchmark code and process was flawed.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-25 Thread Michael Dick
I have not closely examined your benchmark project, so I don't know > > how > > >>>> it > > >>>> compares to Trade and/or SpecJApp work loads. Any thoughts on this > > >>>> topic? > > >>>> > > >>>>