BuilOP

[praj]

I have a buildop doing certain caluculation on an input with aprox 5-6 million od data. In my buildop i am running a loop with 1500 iterations, for each input record. The time this job takes is quiet high. Is there any way of reducing this time? any optimization suggested while working with buildops?

[ray.wurlod]

The obvious one is to research smarter algorithms. For example if your 1500 iterations per row processed is to determine whether something exists in an array, contemplate more efficiently searched data structures.
Even exiting the loop as soon as something has been found, rather than completing all 1500 iterations, might be feasible as an improvement. I'm sure there is a cleverer way to do what your job is doing.

[kduke]

Post enough of the code so we can see how it works.