Hi

I Just starting moving our code form IBO 4_6_BC to 4_9_9, as we having a mega storeprocedure with 522 input params. This SP is basically running 10 other SP in a loop. I thinking of removing it and just run a loop 10 times in the code rather than an SP...anyway, in old IBO it took a good couple of seconds to perpare and since upgraded it takes at least twice as long if not longer.
Just wondering if there is a way of speeding it up. Would it be done by defining the parameters myself... if that is the case what is point that should not use autodefineparams?

Thanks

Richard