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?
> > >>>>
> > >>>>
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.
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
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
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
.
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
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
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
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
>>>
>>>> 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.
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
>>> 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.
>>>
>>>
>>>
>>>
>>
>>
>>
>
>
.
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.
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
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
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.
>
>
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.
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
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
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.
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
> 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.
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
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.
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
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
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.
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.
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
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
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
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.
>
> 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
> > 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
> --
>
. 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.
m/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2490593.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
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
;> [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.
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
>
> 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
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.
return storageCategories;
> >> >>}
> >> >>
> >> >>public void addStorageCategories(Storagecategory
> >> storagecategory)
> >> >> {
> >> >> if(storageCategories == null)
> >> &g
;>
>> >>}
>> >>
>> >> }
>> >>
>> >>
>> >>
>> >> package project.common.model;
>> >>
>> >> import java.util.*;
>> >>
>> >> import javax.persistence.*;
>>
port java.util.*;
>> >>
>> >> import javax.persistence.*;
>> >>
>> >> @Entity
>> >> public class Storagecategory {
>> >>
>> >>@Id
>> >>@GeneratedValue(strategy = GenerationType.IDENTITY)
>>
torageCategoryName;
> >>
> >>@ManyToMany(mappedBy="storageCategories",
> >> cascade={CascadeType.PERSIST})
> >>private List wearhouses;
> >>
> >> public Storagecategory() {
> >>}
> >>
> >>publi
uot;,
> >> cascade={CascadeType.PERSIST})
> >> private List wearhouses;
> >>
> >>public Storagecategory() {
> >>}
> >>
> >>public Storagecategory(String storageCategoryName) {
> >>
public Integer getStoragecategoryNr() {
>>return this.storagecategoryNr;
>>}
>>
>>public void setStoragecategoryNr(Integer storagecategoryNr) {
>> this.storagecategoryNr = storagecategoryNr;
>>}
>>
>>public String getStorageCategoryN
ng storageCategoryName) {
>this.storageCategoryName = storageCategoryName;
>}
>
>public List getWearhouses() {
> return wearhouses;
> }
>
> public void setWearhouses(List wearhouses) {
>this.wearhouses =
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
48 matches
Mail list logo