| Author |
Message
|
| vijayakumar |
 Posted: Wed Aug 17, 2011 3:05 pm Post subject: Database interaction |
 |
|
Centurion
Joined: 01 Aug 2010
Posts: 101
|
| please advise whether Select clause with Item selections fro doing the select query cause any performance overhead. |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Wed Aug 17, 2011 9:12 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Would you care to
1) Give us an example of the SELECT Command you are using?
2) Tell us how is the underlying table and its indexes structured?
At the moment, your question is more like
'How long is a piece of string?
which will get the answer,
'It depends'
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Aug 18, 2011 4:35 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Ask your DBA to give you a performance profile of your query. This is a databsae question which has no answer from WMB since WMB does not incur overhead when calling a database. The overhead is caused by the query itself, not WMB.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 18, 2011 4:49 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Yes.
Every statement causes performance overhead.
It is meaningless to measure or discuss performance outside of a set of requirements.
Your particular statement may cause 1 microsecond of performance overhead or it may cause five hours of performance overhead. It's not possible to say without actually measuring it.
It is equally impossible to determine if either of those overheads is BAD without any REQUIREMENTS for the performance of the system. both of those times may be perfectly fine. Or both may be too slow. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Aug 18, 2011 5:56 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| mqjeff wrote: |
Yes.
Every statement causes performance overhead.
It is meaningless to measure or discuss performance outside of a set of requirements.
Your particular statement may cause 1 microsecond of performance overhead or it may cause five hours of performance overhead. It's not possible to say without actually measuring it.
It is equally impossible to determine if either of those overheads is BAD without any REQUIREMENTS for the performance of the system. both of those times may be perfectly fine. Or both may be too slow. |
In other words,
How long is that bit of string I see poking out of your pocket?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| anandsitha |
| Posted: Thu Aug 18, 2011 6:13 am Post subject: |
|
|
Acolyte
Joined: 26 Jul 2011
Posts: 59
|
Hi vijayakumar-
Write a stored procedure in the db itself. call the stored procedure in your mb.
Regards
Sithanandam.V |
|
| Back to top |
|
|
|
|
