Skip to Content

Procedure Executions is Taking Lot of time

May 25, 2017 at 11:41 AM


avatar image

Hi All,

I have a requirement to write a Procedure to fetch some records based on business Conditions.

From the procedure am able to fetch the records properly,but the execution of preocedure is taking lot of time(3 Minutes).

Version am using is SPS 12 on CAL.

While writing the procedure i used arrays for Looping.But here i used nested For Loop.

Is it ok to write nested for loops or do we have any alternative.

First for loop iterated for 16 times(Static since it has 16 different machines).

Second Forloop(Nested For loop) Iterated for around 200-300 iterates.

could anybody please help me in providing an efficient Solution for this.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers