> 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-HowdoIenableconnectionpoolinginOpenJPA%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.
