tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Gallimore <jonathan.gallim...@gmail.com>
Subject Re: SQL insert taking too much time in TomEE-7.0.1
Date Thu, 02 Nov 2017 11:26:11 GMT
Do you have some sample code and a datasource config (minus anything
sensitive) we could use to test it out and see where the issue is?

Thanks

Jon

On Thu, Nov 2, 2017 at 11:13 AM, Romain Manni-Bucau <rmannibucau@gmail.com>
wrote:

> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message