MQSeries.net :: View topic - Stored Procedure vs Inline Query

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 » Stored Procedure vs Inline Query - Design Choice

Stored Procedure vs Inline Query - Design Choice

« View previous topic :: View next topic »

Author

Message

newbee001

Posted: Thu Aug 04, 2016 6:09 am Post subject: Stored Procedure vs Inline Query - Design Choice

Novice

Joined: 04 Aug 2016
Posts: 10

Hi,

Is it best to write SP or inline SQL query for frequent (not bulk) DB inserts to design my audit component? Assume the volume of the transaction in a day will be 10,000. Looking for pros and cons here.

Thanks in advance.

mqjeff

Posted: Thu Aug 04, 2016 6:35 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

An ESQL passthru might be faster than an ESQL Insert.

A JCN using JDBC might be faster than an ESQL Insert.

The speed of an SP is going to be more dependent on what the SP does, than how or how often it's called.

The performance reports should address some of this.

Running the insert logic in a stand alone flow will reduce the impact on everything else - because they only have to wait for a message to be written, not processed.
_________________
chmod -R ugo-wx /

newbee001

Posted: Thu Aug 04, 2016 6:41 am Post subject:

Novice

Joined: 04 Aug 2016
Posts: 10

Thanks Jeff.. that summarizes everything..

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Stored Procedure vs Inline Query - Design Choice

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