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
