OraFAQ Forum: General » Opinions on this article?

Home » Other » General » Opinions on this article?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Opinions on this article? [message #210296]

Wed, 20 December 2006 03:42

grantpt27
Messages: 5
Registered: December 2006

Junior Member

http://www.tonymarston.net/php-mysql/stored-procedures-are-evil.html

Just read this and am sceptical. Anyone got any comments?

Report message to a moderator

Re: Opinions on this article? [message #210306 is a reply to message #210296]

Wed, 20 December 2006 04:21

Frank
Messages: 7897
Registered: March 2000

Senior Member

Stored procedures in Oracle are not the same as SPs in other databases.
As you can see, he talks about SPs as a replacement for SQL. That is NOT how Oracle SPs are used in general.

But, frankly, I think he doesn't really know what he is talking about if he says that it mangles the 3-tier principle.
His second argument, about how SPs form a maintenance problem is BS too, as is his third argument.
Why would it take more time to test referential integrity if you have an SP compared to when you don't use them???

Again, all he says does simply NOT relate to Oracles stored procedures. The mere thought that SPs would not scale proves that.

Report message to a moderator

Re: Opinions on this article? [message #210405 is a reply to message #210306]

Wed, 20 December 2006 12:04

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Methinks, he is talking about MySQL.
At some point the author says (or that is what i understood) it easier to maintain Business Logic in application and i do not agree with that. I cannot speak for MySQL. But generally databases (specifcally oracle) are designed to do the computing/processing in backend with builtin functions/procedures.

Report message to a moderator

Previous Topic:	applications in pl/sql (Merged cross-posts)
Next Topic:	Oracle 8.0.x connectivity to 9i server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 21 11:03:50 CDT 2023