MQSeries.net :: View topic - Inserting huge message to multiple tables(around 300)

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Inserting huge message to multiple tables(around 300)

Inserting huge message to multiple tables(around 300)

« View previous topic :: View next topic »

Author

Message

prasantkumarmoharana

Posted: Wed Aug 03, 2011 4:49 am Post subject: Inserting huge message to multiple tables(around 300)

Newbie

Joined: 29 Mar 2010
Posts: 9

Hi,

I have a requirement to insert huge message data (3000 fields) into multiple tables (300 tables) using websphere message broker.

I understand their are various options like Database, compute, warehouse node or any other.

Which option would be the best in terms of performance and which will take less time to insert these data?.

Appreciate any help.

mqjeff

Posted: Wed Aug 03, 2011 4:53 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

The best bet would be to call a stored procedure that did the inserts.

Then you pass the data *from* broker to the database *once*.

And the stored procedure can be optimized by the dbas, who are the right people to handle this kind of performance tuning.

benumohta

Posted: Wed Aug 03, 2011 11:49 am Post subject:

Newbie

Joined: 31 May 2006
Posts: 1

Messge Broker is not the ideal tool for such thing. Revisit the architecture.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Inserting huge message to multiple tables(around 300)

Jump to:

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

Protected by Anti-Spam ACP