openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nitish Kumar" <Nitish.Ku...@proteans.com>
Subject RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.
Date Thu, 19 Mar 2009 08:34:48 GMT
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:kwsutter@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.Kumar@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.jones@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." 
-------------------------------------------------------------------------------------------------------------------------


Mime
View raw message