Do you have some sample code and a datasource config (minus anything sensitive) we could use to test it out and see where the issue is?
Thanks Jon On Thu, Nov 2, 2017 at 11:13 AM, Romain Manni-Bucau <rmannibu...@gmail.com> wrote: > Hi > > did you check your datasource pool configuration (you can through JMX > in openejb mbeans)? > > > Romain Manni-Bucau > @rmannibucau | Blog | Old Blog | Github | LinkedIn > > > 2017-11-02 6:35 GMT+01:00 pmo_tomee <mahato1...@gmail.com>: > > Hi Team, > > > > I am using JPA and Hibernate-5.2.8 (as persistence provider) in TomEE. > > Using Oracle 10g DB. > > > > I tested to insert 400 rows in TomEE and JONAS server. TomEE taking 20 > sec > > but jonas taking only 4 sec. > > > > I have tested in TomEE with batch insert by <property > > name="hibernate.jdbc.batch_size" value="50" /> but taking 20 sec aslo. > > > > I have checked the log in Oracle for both server given below. > > > > *JONAS server* > > -------------------- > > call count cpu elapsed disk query current > > rows > > ------- ------ -------- ---------- ---------- ---------- ---------- > > ---------- > > Parse 1 0.00 0.00 0 0 0 > > 0 > > Execute 26 0.11 0.16 10 20 7331 > > 380 > > Fetch 0 0.00 0.00 0 0 0 > > 0 > > ------- ------ -------- ---------- ---------- ---------- ---------- > > ---------- > > total 27 0.11 0.16 10 20 7331 > > 380 > > > > *Here JONAS inserting 380 rows by 26 Executions* > > > > ------------------------------------------------------------ > ------------------------ > > TomEE server > > ------------------------- > > call count cpu elapsed disk query current > > rows > > ------- ------ -------- ---------- ---------- ---------- ---------- > > ---------- > > Parse 380 0.01 0.01 0 0 0 > > 0 > > Execute 380 1.26 1.28 9 393 6218 > > 380 > > Fetch 0 0.00 0.00 0 0 0 > > 0 > > ------- ------ -------- ---------- ---------- ---------- ---------- > > ---------- > > total 760 1.27 1.30 9 393 6218 > > 380 > > > > *Here TomEE inserting 380 rows by 380 executions* > > > > Could you help me why TomEE taking 20 sec to insert. > > > > Is there any way to fixed it ? > > > > Thanks & Regards > > Prasenjit Mahato > > mahato1...@gmail.com > > > > > > > > -- > > Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users- > f979441.html >
