| Author |
Message
|
| wmberg |
 Posted: Fri Mar 21, 2014 4:27 am Post subject: Performance of stored procedures WMB vs ICS |
 |
|
Newbie
Joined: 21 Mar 2014
Posts: 3
|
| We appear to have a performance issue when calling oracle stored procedures from Message Broker. The equivalent call from ICS is substantially quicker. Are there any known issues. |
|
| Back to top |
|
 |
| McueMart |
| Posted: Fri Mar 21, 2014 4:42 am Post subject: |
|
|
Chevalier
Joined: 29 Nov 2011
Posts: 490
Location: UK...somewhere
|
| What version of WMB? What have you done to isolate the issue to ensure that it's definitely a WMB problem, and not related to some of the code in the flows? Have you looked at enabling ODBC trace to try and track down the issue? |
|
| Back to top |
|
|
| wmberg |
| Posted: Fri Mar 21, 2014 4:46 am Post subject: |
|
|
Newbie
Joined: 21 Mar 2014
Posts: 3
|
| 8.0.0.2 calling procedures on Oracle 8. Trace points just before and just after the calls. |
|
| Back to top |
|
|
| wmberg |
| Posted: Fri Mar 21, 2014 7:31 am Post subject: |
|
|
Newbie
Joined: 21 Mar 2014
Posts: 3
|
It appears that this is only in one particular flow. In other flows WMB is outperforming ICS.
I'll get my shovel and do some more digging. |
|
| Back to top |
|
|
| McueMart |
| Posted: Fri Mar 21, 2014 8:39 am Post subject: |
|
|
Chevalier
Joined: 29 Nov 2011
Posts: 490
Location: UK...somewhere
|
|
| Back to top |
|
|
|
|
