DB operation are slow

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

DB operation are slow

Nikhil
Hi All,

We are using OpenESB 3 standalone server on Red Hat Enterprise Linux Server
release 7.4 (Maipo).
RAM is 15 GB.
We are finding that for a large number of database inserts/updates
performance is really slow.
CRUD operations are slow.

KIndly suggest

Thanks,
Nikhil



--
Sent from: http://openesb-community-forum.794670.n2.nabble.com/
Reply | Threaded
Open this post in threaded view
|

Re: DB operation are slow

Paul Perez
Administrator
Hello Nikhil

Could you detail what is, from your point of view a large number of Insert
update.
Could you detail your Case and context as well.
OpenESB is using directly the JDBC framework provided by your JVM and the
drivers provided by the Editor. The only part added by the OpenESB framework
is the JNDI registry that provides a Mapping between a JNDI name and the
connection. It is used at the OpenESB start only.  
Up to now, we did not get this kind of feedback from the users. So, yours is
very interesting to understand your case.

Regards

Paul
Pymma Consulting



-----Original Message-----
From: User <[hidden email]> On Behalf Of Nikhil
Sent: 09 July 2018 11:28
To: [hidden email]
Subject: [User] DB operation are slow

Hi All,

We are using OpenESB 3 standalone server on Red Hat Enterprise Linux Server
release 7.4 (Maipo).
RAM is 15 GB.
We are finding that for a large number of database inserts/updates
performance is really slow.
CRUD operations are slow.

KIndly suggest

Thanks,
Nikhil



--
Sent from: http://openesb-community-forum.794670.n2.nabble.com/

www.pymma.com The best services on OpenESB
Reply | Threaded
Open this post in threaded view
|

Re: DB operation are slow

Nikhil
Hi Paul,

Thanks for replying.
First of all we are not using JDBC BC .
we are doing all CRUD operations from java.
we re using all connection related properties from context.xml in which in
defining.
In Open ESB 2.2 code was working fine but after  migrating to OPENESB  3
standalone CRUD operation is working slow.

Here is parameter of context.xm file we define for connection.

<dataSource-pool-properties>
        <dbConnector-name>oracleESBPool</dbConnector-name>
       
<datasource-classname>oracle.jdbc.xa.client.OracleXADataSource</datasource-classname>
        <resource-type>Datasource</resource-type>
        <database-name>Oracle</database-name>
        <database-vendor>Oracle</database-vendor>
        <database-version>11</database-version>
        <dbconnector-description>DBConnector for Oracle
XA</dbconnector-description>
        <dataSource-properties>
            <property>
                <name>user</name>
                <value>XXXXXXX</value>
                <description></description>
            </property>
            <property>
                <name>password</name>
                <value>XXXXX</value>
                <description></description>
            </property>
            <property>
                <name>serverName</name>
                <value>XXXXX</value>
                <description></description>
            </property>
            <property>
                <name>portNumber</name>
                <value>XXXX</value>
                <description></description>
            </property>
            <property>
                <name>databaseName</name>
                <value>XXXXXX</value>
                <description></description>
            </property>
            <property>
                <name>driverType</name>
                <value>thin</value>
                <description></description>
            </property>
        </dataSource-properties>
        <pool-properties>
            <property>
                <name>initialSize</name>
                <value>10</value>
                <description></description>
            </property>
            <property>
                <name>maxActive</name>
                <value>20</value>
                <description></description>
            </property>
            <property>
                <name>maxIdle</name>
                <value>9</value>
                <description></description>
            </property>
            <property>
                <name>minIdle</name>
                <value>9</value>
                <description></description>
            </property>
                <property>
                        <name>testOnCreate</name>
                        <value>false</value>
                </property>
                <property>
                <name>testOnBorrow</name>
                <value>true</value>
           </property>
               <property>
                <name>testOnReturn</name>
                <value>false</value>
           </property>
               <property>
                <name>testWhileIdle</name>
                <value>false</value>
           </property>
               <property>
                <name>numTestsPerEvictionRun</name>
                <value>3</value>
           </property>
                   <property>
                <name>lifo</name>
                <value>true</value>
           </property>
                <property>
                <name>maxConnLifetimeMillis</name>
                <value>120000</value>
           </property>
        </pool-properties>
    </dataSource-pool-properties>


Thanks,
Nikhil




--
Sent from: http://openesb-community-forum.794670.n2.nabble.com/
Reply | Threaded
Open this post in threaded view
|

Re: FW: DB operation are slow

Martí Pàmies Solà

Hi Nikhil

Could you provide some more detail on % increasing, and the amount of insert per second? In one of my active projects, I am inserting XML documents into Oracle with OE Standalone and I am not facing this issue.

Also could be interesting to have information on JRE and JDBC Driver versions?

Regards,

Martí


El 09/07/2018 a les 13:16, Paul Perez ha escrit:

-----Original Message-----
From: User [hidden email] On Behalf Of Nikhil
Sent: 09 July 2018 11:56
To: [hidden email]
Subject: Re: [User] DB operation are slow

Hi Paul,

Thanks for replying.
First of all we are not using JDBC BC .
we are doing all CRUD operations from java.
we re using all connection related properties from context.xml in which in
defining.
In Open ESB 2.2 code was working fine but after  migrating to OPENESB  3
standalone CRUD operation is working slow.

Here is parameter of context.xm file we define for connection.

<dataSource-pool-properties>
        <dbConnector-name>oracleESBPool</dbConnector-name>
       
<datasource-classname>oracle.jdbc.xa.client.OracleXADataSource</datasource-c
lassname>
        <resource-type>Datasource</resource-type>
        <database-name>Oracle</database-name>
        <database-vendor>Oracle</database-vendor>
        <database-version>11</database-version>
        <dbconnector-description>DBConnector for Oracle
XA</dbconnector-description>
        <dataSource-properties>
            <property>
                <name>user</name>
                <value>XXXXXXX</value>
                <description></description>
            </property>
            <property>
                <name>password</name>
                <value>XXXXX</value>
                <description></description>
            </property>
            <property>
                <name>serverName</name>
                <value>XXXXX</value>
                <description></description>
            </property>
            <property>
                <name>portNumber</name>
                <value>XXXX</value>
                <description></description>
            </property>
            <property>
                <name>databaseName</name>
                <value>XXXXXX</value>
                <description></description>
            </property>
            <property>
                <name>driverType</name>
                <value>thin</value>
                <description></description>
            </property>
        </dataSource-properties>
        <pool-properties>
            <property>
                <name>initialSize</name>
                <value>10</value>
                <description></description>
            </property>
            <property>
                <name>maxActive</name>
                <value>20</value>
                <description></description>
            </property>
            <property>
                <name>maxIdle</name>
                <value>9</value>
                <description></description>
            </property>
            <property>
                <name>minIdle</name>
                <value>9</value>
                <description></description>
            </property>
	        <property>
		        <name>testOnCreate</name>
		        <value>false</value>
	        </property>
	        <property>
                <name>testOnBorrow</name>
                <value>true</value>
           </property>
	       <property>
                <name>testOnReturn</name>
                <value>false</value>
           </property>
	       <property>
                <name>testWhileIdle</name>
                <value>false</value>
           </property>
	       <property>
                <name>numTestsPerEvictionRun</name>
                <value>3</value>
           </property>
		   <property>
                <name>lifo</name>
                <value>true</value>
           </property>
	 	       <property>
                <name>maxConnLifetimeMillis</name>
                <value>120000</value>
           </property>
        </pool-properties>
    </dataSource-pool-properties>


Thanks,
Nikhil 




--
Sent from: http://openesb-community-forum.794670.n2.nabble.com/




--
Martí Pàmies Solà
Health Systems Interoperability Engineer
t +34 933 89 48 61 | m +34 649 60 87 43 | f +34 933 84 21 49
Reply | Threaded
Open this post in threaded view
|

Re: FW: DB operation are slow

Nikhil
HI Martí,

JAVA Vesion is Java(TM) SE Runtime Environment (build 1.8.0_161-b12
Oracle JDBC Drive is ojdbc6.jar .

Please sugggest what parameter we can define in context.xml so CRUD
operation will be executed  properly.

Thanks,

Nikhil






--
Sent from: http://openesb-community-forum.794670.n2.nabble.com/
Reply | Threaded
Open this post in threaded view
|

Re: FW: DB operation are slow

OpenESB Community Forum mailing list

Hi Nikhil ,

At first glance your context.xml is correct, and although in my case is different as I use TNS Entry, it should works.

Some questions/considerations:

  • When you mean CRUD, are you using Statements? I mean <jdbc:input  ...    sql="INSERT INTO ..."
  • Did you try to perform to same insert from a jdbc compliant tool like DBVisualizer using the same JRE and JDBC? Is the execution time the same?
  • Is your Oracle DB 12.x? if it is, you should use ojdbc7.jar driver as JRE is 8.

Regards,

Martí


El 10/07/2018 a les 9:40, Nikhil ha escrit:
HI Martí,

JAVA Vesion is Java(TM) SE Runtime Environment (build 1.8.0_161-b12
Oracle JDBC Drive is ojdbc6.jar .

Please sugggest what parameter we can define in context.xml so CRUD
operation will be executed  properly.

Thanks,

Nikhil 






--
Sent from: http://openesb-community-forum.794670.n2.nabble.com/