On Tue, Oct 7, 2008 at 6:31 PM, Ricardo Araoz <[EMAIL PROTECTED]> wrote: > I don't like stored procedures. > > Why? Because you can not do 'everything' pertaining the data base with > them. So you will end up with some of the code you use for your data in > stored procedures and some of the code in your business layer. And I do > not like that, I'd rather have everything in the same place. > What do you think about this? -------------------------------------------------------
Your kidding right? An SP is a specific code segment to achieve a goal. I have seen some that were in excess of 40,000 lines of code and took about 3 to 4 days to run. OK it remapped all activity at a hospital since data existed and took in events that were being added from outside med facilities. It was cool as shit tough. This case had 1 sp to call 20+ SPs. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
