| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database node performance |
« View previous topic :: View next topic » |
| Author |
Message
|
| Yanghui |
 Posted: Wed Feb 26, 2003 9:43 am Post subject: Database node performance |
 |
|
Disciple
Joined: 08 May 2002
Posts: 151
Location: Dublin, Ireland
|
I have been knowing that database node (or any database operation) could have huge impact on msgflow performance. From the performance report (SupportPac IP67) for Sun Solaris, it still can reach 36 msgs per second for 1k persistence msgs on DB2.
I have a very simple msgflow with one MQInput node, one database node and one MQOutput node. I am using local Oracle db. The database node is only to treat incoming msg as blob and insert it in db. For average length 1k msgs, I only get about 5 msgs per second. Is this normal?
Does anybody know something missing here to cause the poor performance? Is there any good way to increase db throughput in msgflow?
Thanks a lot
Regards
-Yanghui |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Feb 27, 2003 10:05 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
DB operations (Insert/Update) are very costly. If you don't have any message dependency then try running multiple instances of this message flow to increase your throughput. I'd also recommend that you watch for CPU utilization when running this message flow. Pls make sure you don't have Trace enabled on your Message flow or Execution Group.
What version for WMQI are you using?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Yanghui |
| Posted: Fri Feb 28, 2003 2:49 am Post subject: |
|
|
Disciple
Joined: 08 May 2002
Posts: 151
Location: Dublin, Ireland
|
Hi, Kirani,
Thanks a lot for your reply.
I am using WMQI2.1 CSD4 with broker on Solaris, Oracle 8i as broker db.
There was no any trace on when doing the performance testing.
Regards
-Yanghui |
|
| 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
|
|
|
|
