Skip to Content

Procedure Executions is Taking Lot of time

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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers