Hi Prasenjit Mahato,
Could you possibly create and share a github project so that we can
debug this use case?
I've used Hibernate & TomEE in production for many years, so I'm very
sure that we can find out what is wrong. It's just very hard to know
without all the information.
Also, please 'create' a ticket on the TomEE JIRA here:
https://issues.apache.org/jira/projects/TOMEE
Thanks,
Andy.
On 02/11/17 06:32, pmo_tomee wrote:
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-Dev-f982480.html
--
Andy Gumbrecht
https://twitter.com/AndyGeeDe
http://www.tomitribe.com
https://www.tomitribe.io
