Re: JPA vs DBUtils

2017-06-21 Thread sgjava
about not optimizing the JPA entity class. Things are much closer now. Latest is on Github https://github.com/sgjava/jpavsdbutils -- View this message in context: http://tomee-openejb.979440.n4.nabble.com/JPA-vs-DBUtils-tp4681918p4681939.html Sent from the TomEE Users mailing list archive

Re: JPA vs DBUtils

2017-06-21 Thread Andy Gumbrecht
me data set) for JPA: > > > > > > > > ` ` no > > difference > > > > PersistenceContextType.TRANSACTION > > > > @Singleton > > > > > > > > DBUtils bean is still using @Stateful since I do not want to create > > > > QueryRunner

Re: JPA vs DBUtils

2017-06-21 Thread Romain Manni-Bucau
e to DBUtils? > > > > > > Jun 20, 2017 9:39:40 PM com.codeferm.jpavsdbutils.PerformanceTest > > > performance > > > INFO: JPA add elapsed milliseconds: 4765 > > > Jun 20, 2017 9:39:40 PM com.codeferm.jpavsdbutils.PerformanceTest > > > performance > > > INFO: JPA get elapsed milliseconds: 323 > > > Jun 20, 2017 9:39:45 PM com.codeferm.jpavsdbutils.PerformanceTest > > > performance > > > INFO: JPA delete elapsed milliseconds: 5035 > > > > > > Jun 20, 2017 9:39:47 PM com.codeferm.jpavsdbutils.PerformanceTest > > > performance > > > INFO: DbUtils add elapsed milliseconds: 1757 > > > Jun 20, 2017 9:39:47 PM com.codeferm.jpavsdbutils.PerformanceTest > > > performance > > > INFO: DbUtils get elapsed milliseconds: 67 > > > Jun 20, 2017 9:39:48 PM com.codeferm.jpavsdbutils.PerformanceTest > > > performance > > > INFO: DbUtils delete elapsed milliseconds: 895 > > > > > > > > > > > > > > > -- > > > View this message in context: http://tomee-openejb.979440. > > > n4.nabble.com/JPA-vs-DBUtils-tp4681918p4681932.html > > > Sent from the TomEE Users mailing list archive at Nabble.com. > > > > > > > > > -- > Steven P. Goldsmith >

Re: JPA vs DBUtils

2017-06-21 Thread Steve Goldsmith
.PerformanceTest > > performance > > INFO: JPA delete elapsed milliseconds: 5035 > > > > Jun 20, 2017 9:39:47 PM com.codeferm.jpavsdbutils.PerformanceTest > > performance > > INFO: DbUtils add elapsed milliseconds: 1757 > > Jun 20, 2017 9:39:47 PM com.codeferm.jpavsdbutils.PerformanceTest > > performance > > INFO: DbUtils get elapsed milliseconds: 67 > > Jun 20, 2017 9:39:48 PM com.codeferm.jpavsdbutils.PerformanceTest > > performance > > INFO: DbUtils delete elapsed milliseconds: 895 > > > > > > > > > > -- > > View this message in context: http://tomee-openejb.979440. > > n4.nabble.com/JPA-vs-DBUtils-tp4681918p4681932.html > > Sent from the TomEE Users mailing list archive at Nabble.com. > > > -- Steven P. Goldsmith

Re: JPA vs DBUtils

2017-06-21 Thread hwaastad
the most effecient sql when it comes to N+1or when it comes to handle large collections and lazyness... /hw -- View this message in context: http://tomee-openejb.979440.n4.nabble.com/JPA-vs-DBUtils-tp4681918p4681934.html Sent from the TomEE Users mailing list archive at Nabble.com.

Re: JPA vs DBUtils

2017-06-21 Thread Romain Manni-Bucau
manceTest > performance > INFO: DbUtils get elapsed milliseconds: 67 > Jun 20, 2017 9:39:48 PM com.codeferm.jpavsdbutils.PerformanceTest > performance > INFO: DbUtils delete elapsed milliseconds: 895 > > > > > -- > View this message in context: http://tomee-openejb.979440. > n4.nabble.com/JPA-vs-DBUtils-tp4681918p4681932.html > Sent from the TomEE Users mailing list archive at Nabble.com. >

Re: JPA vs DBUtils

2017-06-20 Thread sgjava
/JPA-vs-DBUtils-tp4681918p4681932.html Sent from the TomEE Users mailing list archive at Nabble.com.

Re: JPA vs DBUtils

2017-06-20 Thread Steve Goldsmith
since it was exactly the same since and number of entities :) I still changed the test to use the exact same data and I'm making the other changes as well. On Tue, Jun 20, 2017 at 6:25 PM, Andy Gumbrecht <agumbre...@tomitribe.com> wrote: > Steve, > > The issue here is that the

Re: JPA vs DBUtils

2017-06-20 Thread Andy Gumbrecht
Steve, The issue here is that the JPA vs DBUtils comparison is not really valid, and the example is nothing like a benchmark. TomEE can't be put on the hotplate for Hibernate/JPA, which is a huge huge topic with tons and tons of documentation. TomEE is 'just' the 'enabler' here. If you

Re: JPA vs DBUtils

2017-06-20 Thread Romain Manni-Bucau
long reading session with > > > > > http://java-persistence-performance.blogspot.com/? I found that > > site > > > > > invaluable. > > > > > > > > > > Best, > > > > > Laird > > > > > -- > > &g

Re: JPA vs DBUtils

2017-06-20 Thread Steve Goldsmith
; > > > > > > I just built a project to compare JPA+Hibernate to a DBUtils > > > > > implementation. > > > > > DBUtils is a lot faster by a large margin. Can anyone tell me if > they > > > > have > > > >

Re: JPA vs DBUtils

2017-06-20 Thread Romain Manni-Bucau
> > I just built a project to compare JPA+Hibernate to a DBUtils > > > > implementation. > > > > DBUtils is a lot faster by a large margin. Can anyone tell me if they > > > have > > > > tuned JPA to perform better? I used TomEE 7.0.4-SNAPSHOT. I

Re: JPA vs DBUtils

2017-06-20 Thread Steve Goldsmith
used TomEE 7.0.4-SNAPSHOT. I could live > > with > > > maybe a 10% difference, but I'm talking about 10 to 10 times slower! > > > > > > https://github.com/sgjava/jpavsdbutils > > > > > > > > > > > > -- > > > View this message in context:

Re: JPA vs DBUtils

2017-06-20 Thread Romain Manni-Bucau
ed TomEE 7.0.4-SNAPSHOT. I could live > > with > > > maybe a 10% difference, but I'm talking about 10 to 10 times slower! > > > > > > https://github.com/sgjava/jpavsdbutils > > > > > > > > > > > > -- > > > View this message in context: > > > http://tomee-openejb.979440.n4.nabble.com/JPA-vs-DBUtils- > tp4681918.html > > > Sent from the TomEE Users mailing list archive at Nabble.com. > > > > > > > > > -- > Andy Gumbrecht > https://twitter.com/AndyGeeDe > http://www.tomitribe.com >

Re: JPA vs DBUtils

2017-06-20 Thread Andy Gumbrecht
lking about 10 to 10 times slower! > > > > https://github.com/sgjava/jpavsdbutils > > > > > > > > -- > > View this message in context: > > http://tomee-openejb.979440.n4.nabble.com/JPA-vs-DBUtils-tp4681918.html > > Sent from the TomEE Users mailing list archive at Nabble.com. > > > -- Andy Gumbrecht https://twitter.com/AndyGeeDe http://www.tomitribe.com

Re: JPA vs DBUtils

2017-06-19 Thread Laird Nelson
hub.com/sgjava/jpavsdbutils > > > > -- > View this message in context: > http://tomee-openejb.979440.n4.nabble.com/JPA-vs-DBUtils-tp4681918.html > Sent from the TomEE Users mailing list archive at Nabble.com. >

JPA vs DBUtils

2017-06-19 Thread sgjava
! https://github.com/sgjava/jpavsdbutils -- View this message in context: http://tomee-openejb.979440.n4.nabble.com/JPA-vs-DBUtils-tp4681918.html Sent from the TomEE Users mailing list archive at Nabble.com.