At 01:22 PM 6/24/2004, Sudheer Palaparambil wrote:

> How lengthy a SP can be ?

Longer than you can possibly debug.

> Will it's length effect it's performance?

Yes - if you can't debug it, the performance will be abysmal.

> And is there any limit on the number of SPs
>for a particular DB?

I'm sure there is, and it's probably on the order of 32K. Use
lots of small ones and call them like subroutines.



Regards,

Ann
www.ibphoenix.com
We have answers.