Re: Q: Do Stored Procedures actually degrade performance?

In article <6h8ihq$nu8$1@news.xmission.com>, Sujit.Pal@alltel.com writes > In any case we found the EXPLAIN PLANs were clean in the SPs. We > obtained some (around 10%) gains by moving SPL global variables into > the local variables for SPLs. We are investigating the problem further > and will let this group know if we uncover anything. > Any chance you could post and example stored procedure? > > Thanks for all your help. > > Sujit > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care