Adam Posted December 16, 2009 Share Posted December 16, 2009 http://www.tonymarston.net/php-mysql/stored-procedures-are-evil.html I have to agree. Although it's fair to say I generally only ever use PL/SQL for stored procedures and they're awful IMO. Quote Link to comment Share on other sites More sharing options...
premiso Posted December 16, 2009 Share Posted December 16, 2009 When I was coding in .NET Studio with SQL Server, they were a god send for the C# / ASP applications we were working on. Also when I used them in Oracle for an old database to pull up reports they were pretty awesome. It all depends on how you need to use them. I have never used them in MySQL, so I cannot vouch for that. Quote Link to comment Share on other sites More sharing options...
Mchl Posted December 16, 2009 Share Posted December 16, 2009 I pretty much agree with most of the points. Just about only reason I use them is performance. I also use triggers to enforce non trivial data constraints. Still, I wouldn't go as far as calling them evil. They're but a tool and it's up to a developer to use it wisely. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.