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/%7Eppoddar/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-performance-with-OpenJPA-when-selecting-from-a%0A-ManyToMany-relation.-tp2466994p2493009.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."
>
> -------------------------------------------------------------------------------------------------------------------------
>
>
