| Re: Stored Procedures
Ajoy,
You've hit against the main disadvantage of stored procedures within OTM. The App server utilizes many large caches in order to maintain performance levels. Disabling these caches isn't an option within the application -- and if it was, would degrade performance significantly.
The only supported way to ensure that these changes are immediately reflected are to utilize Agents with DirectSQL, so that the application becomes aware of the execution and then updates the appropriate caches. The disadvantage of this approach is that Agents are significantly more expensive (in terms of performance) than stored procedures.
Thanks!
--Chris |