| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Multiple Row Inserts using Compute or Database Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| satya2481 |
 Posted: Sat Sep 20, 2014 4:54 pm Post subject: Multiple Row Inserts using Compute or Database Node |
 |
|
Disciple
Joined: 26 Apr 2007
Posts: 170
Location: Bengaluru
|
Hi All,
We are having a requirement to speed up the Insert process, hence need to insert multiple rows in the database at a time. Below I am providing the details. Can anyone suggest how to achieve this.
Environment Details
WebSphere Message Broker - V7 - zLinux
DB2 Databse - V10.1 - z/OS
Message Flow
MQInput Node -> Compute Node
MQInput Node -> Receives XML Message with data to be inserted in the table
Compute Node -> Receives the data and inserts it into a Audit table
We are planning to modify this flow to collect 10-20 input messages in cache and then do a bulk insert into the table. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Sun Sep 21, 2014 12:14 am Post subject: Re: Multiple Row Inserts using Compute or Database Node |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| satya2481 wrote: |
Hi All,
We are having a requirement to speed up the Insert process, hence need to insert multiple rows in the database at a time. Below I am providing the details. Can anyone suggest how to achieve this.
Environment Details
WebSphere Message Broker - V7 - zLinux
DB2 Databse - V10.1 - z/OS
Message Flow
MQInput Node -> Compute Node
MQInput Node -> Receives XML Message with data to be inserted in the table
Compute Node -> Receives the data and inserts it into a Audit table
We are planning to modify this flow to collect 10-20 input messages in cache and then do a bulk insert into the table. |
Change your design. Handle one message at a time and change the commit load of the flow. This way you can set commit load of 100 for example...
Of course you are using a prepared statement for the insert, right?
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| satya2481 |
| Posted: Thu Sep 25, 2014 3:06 pm Post subject: |
|
|
Disciple
Joined: 26 Apr 2007
Posts: 170
Location: Bengaluru
|
| Quote: |
| prepared statement for the insert, right? |
Could you please share some more information on this? We are using Passthru function and passing the INSERT query. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
