| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| performance when writing database in MB |
« View previous topic :: View next topic » |
| Author |
Message
|
| wangchengsi |
 Posted: Mon Jun 16, 2008 3:45 am Post subject: performance when writing database in MB |
 |
|
Newbie
Joined: 05 Jun 2008
Posts: 5
|
i heard that it's not recommended to modify(insert, update and delete) database table in MB, because it needs transaction and it often cause lower performance. It's better to read database only and put writing request into MQ and let other module,such as J2EE application to write db.
is that so? Or any improvements about database operations in WMB 6.1? |
|
| Back to top |
|
 |
| fschofer |
| Posted: Mon Jun 16, 2008 5:20 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
never had trouble with writing to databases with MB or heard such a recommodation.
What are your perfomance requirements ?
Greetings
Frank |
|
| Back to top |
|
|
| wangchengsi |
| Posted: Mon Jun 16, 2008 7:06 pm Post subject: |
|
|
Newbie
Joined: 05 Jun 2008
Posts: 5
|
there will be lots of logging operation in my MB flow , these logging are simple, just operate one table at a time, but other J2EE application may read these log record at the same time , so it needs transaction, and may slow the main flow .
maybe i can put logging message in another queue, and let another subflow to do logging |
|
| 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
|
|
|
|
