tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pmo_tomee <mahato1...@gmail.com>
Subject SQL insert taking too much time in TomEE-7.0.1
Date Thu, 02 Nov 2017 05:35:41 GMT
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
mahato1987@gmail.com



--
Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-f979441.html

Mime
View raw message