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 <[email protected]>: > 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 > [email protected] > > > > -- > Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-f979441.html
