Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

How do I improve performance of my e-script?

edited Jul 3, 2019 5:09AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 4 commentsAnswered

I was tasked to update a function of a business service and we hit an issue with performance. With the old code, it usually takes 6 minutes to process 3500 records but now, it takes 1 minute to process only two records. I only added a new query and a date function so I'm thinking what I did wrong. I'm planning to create a trace SQL for this but can you help me just by looking at the code what mistake I did? I enclosed the code I added with /*******************************/

function UpdateTestResult(psFileValues:PropertySet):chars

{

//Declarations

var boTestRun:BusObject;

var bcTestRun:BusComp;

var boeEvents:BusObject;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center