tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Romain Manni-Bucau <rmannibu...@gmail.com>
Subject Re: SQL insert taking too much time in TomEE-7.0.1
Date Thu, 02 Nov 2017 11:13:21 GMT
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 <mahato1987@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
> mahato1987@gmail.com
>
>
>
> --
> Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-f979441.html

Mime
View raw message