Yes Pinaki,
Its just that I realized today that hibernate uses a built in
connection pool, so adding a connection pool to open Jpa would not bias
the comparison.
Further to Kevin's point, I am not planning to publish any benchmark, I
am just evaluation openJpa as an alternative to hibernate for my future
projects. I already have a lots of positives in favor of open jpa, guess
performance was one of the widely publicized concerns for open jpa. So I
decided to get my hands dirty and find out for myself.
Thanks and Regards,
Nitish Kumar
-----Original Message-----
From: Pinaki Poddar [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 was the first thing mentioned while we looked at this issue several
days ago.
> I ran the Wearhouse-StorageCategory model you have posted (thank you
for
> a clean test). Against
> 500 categories and 200 wearhouses and a cardinality of 10 categories
per
> wearhouse. The domain
> classes were enhanced at build-time. The database is MySQL and the
tests
> ran in my pedestrian
> laptop. Here are the results for finding Wearhouses 500 times in a
loop.
Without connection pool : 2360 ms.
With connection pool : 734ms
Few comments:
1. If performance is higher priority than ordering, consider using
Set<>
instead of List<>
2. Consider using a connection pool, if possible [1]
[1]
http://openjpa.apache.org/faq.html#FAQ-HowdoIenableconnectionpoolinginOp
enJPA%253F
Regards --
Nitish Kumar wrote:
>
> Hi guys,
> I just realized that Hibernate has its own connection pool which
> it uses, Once you configure Open Jpa with a connection pool as
mentioned
> here
>
http://webspherepersistence.blogspot.com/2009/01/jpa-connection-pooling.
> html , the numbers drop drastically. Hope that helps to do a fair
> 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 interesting bit of information... 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
> benchmarks are done...
>
> Kevin
>
> On Wed, Mar 18, 2009 at 6:59 AM, Nitish Kumar
> <nitish.ku...@proteans.com>wrote:
>
>> Hi,
>> My stats on this, I just ran it on Win XP (JRE 1.5.0_14) and
>> local MySQL, took an average of 3.8 sec to complete 500 iterations.
>> Removed the many to many association, doesn't affect the numbers
much.
>> Make the fetch as eager and it takes 4.2 sec.
>>
>> Something weird here, added the setting <property
>> name="openjpa.jdbc.DBDictionary" value="JoinSyntax=traditional"/> and
> it
>> goes up to 7.2 sec with eager and 4 sec with lazy.
>>
>> PS: I still could not make the enhancer work with ANT so I wrote a
>> simple class
>>
>> public static void main(String[] args) {
>> Collection listFiles = FileUtils.listFiles(new
>> File("./src/model"),
>> new String[] { "java" }, true);
>> for (Object object : listFiles) {
>> File file = (File) object;
>> String[] args1 = new String[] { file.getPath()
>> };
>> PCEnhancer.main(args1);
>> }
>> }
>>
>> it has 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 with OpenJPA when selecting from a
>> ManyToMany relation.
>>
>>
>> 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 me, and installed it on my
own
>> laptop in a new workspace, and what do you know.. It took 2.3 sec.
>> compared
>> to the 12-15 sec.
>>
>> Now, I still don't know the root of the cause, since we have tried it
> on
>> multiple computers at work, but at least this confirms that the
> project
>> itself is working.
>>
>> Btw Pinaki, your plugin works perfect with MyEclipse 7.1.1 aswell.
> FYI.
>> Nice
>> work ;)
>>
>> Shubbis
>>
>> PS: adding the project if anyone wants to see. This is without all
Ant
>> and
>> OpenJPA jar files as they were to big to upload here.
>>
>> http://n2.nabble.com/file/n2493009/OpenJPASISTETEST.rar
>> OpenJPASISTETEST.rar
>>
>>
>> Pinaki Poddar wrote:
>> >
>> > Hi,
>> >> 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.
>> >
>> > 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/<http://people.apache.org/%7Ep
> poddar/eclipse/>
>> >
>> >
>>
>>
>>
>> --
>> View this message in context:
>>
>
http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a
>>
>
-ManyToMany-relation.-tp2466994p2493009.html<http://n2.nabble.com/Slow-p
>
erformance-with-OpenJPA-when-selecting-from-a%0A-ManyToMany-relation.-tp
> 2466994p2493009.html>
>> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>>
>>
>>
>>
>
------------------------------------------------------------------------
> -------------------------------------------------
>> "The information contained in this e-mail transmission is
confidential
> and
>> may be privileged. It is intended only for the
>> addressee(s) stated above. If you are not an addressee, any use,
>> dissemination, distribution, publication, or copying of
>> the information contained in this e-mail is strictly prohibited. If
> you
>> have received this e-mail in error, please
>> immediately notify us by telephone (+91 80 6618 6555), or e-mail the
> sender
>> and delete the e-mail from your system.
>> If you do not want to receive our emails please let us know so that
we
> may
>> delete you from our email list. Proteans
>> Software Solutions and its parent group ("CAMO Group") do not accept
>> liability for damage caused by this email, and may
>> monitor email traffic."
>>
>>
>
------------------------------------------------------------------------
> -------------------------------------------------
>>
>>
>
>
------------------------------------------------------------------------
-------------------------------------------------
> "The information contained in this e-mail transmission is confidential
and
> may be privileged. It is intended only for the
> addressee(s) stated above. If you are not an addressee, any use,
> dissemination, distribution, publication, or copying of
> the information contained in this e-mail is strictly prohibited. If
you
> have received this e-mail in error, please
> immediately notify us by telephone (+91 80 6618 6555), or e-mail the
> sender and delete the e-mail from your system.
> If you do not want to receive our emails please let us know so that we
may
> delete you from our email list. Proteans
> Software Solutions and its parent group ("CAMO Group") do not accept
> liability for damage caused by this email, and may
> monitor email traffic."
>
------------------------------------------------------------------------
-------------------------------------------------
>
>
>
-----
Pinaki Poddar http://ppoddar.blogspot.com/
http://www.linkedin.com/in/pinakipoddar
OpenJPA PMC Member/Committer
JPA Expert Group Member
--
View this message in context:
http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a
-ManyToMany-relation.-tp2466994p2503460.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
-------------------------------------------------------------------------------------------------------------------------
"The information contained in this e-mail transmission is confidential and may
be privileged. It is intended only for the
addressee(s) stated above. If you are not an addressee, any use, dissemination,
distribution, publication, or copying of
the information contained in this e-mail is strictly prohibited. If you have
received this e-mail in error, please
immediately notify us by telephone (+91 80 6618 6555), or e-mail the sender and
delete the e-mail from your system.
If you do not want to receive our emails please let us know so that we may
delete you from our email list. Proteans
Software Solutions and its parent group ("CAMO Group") do not accept liability
for damage caused by this email, and may
monitor email traffic."
-------------------------------------------------------------------------------------------------------------------------
