Stored Procedure FUD

I was just chatting to a friend of mine who runs an online business, he was asking me about stored procs because he had been told by two people (including someone who works at the hosting company) that stored procs don't scale!

Apparrently, you can't use them in a cluster or any sort of balanced environment.

Now, obviously this is total BS, has anyone come across this sort of FUD before ? I'd love to know the origin of this.

 

Print | posted on Tuesday, March 09, 2004 7:50 PM

Comments on this post

# re: Stored Procedure FUD

Requesting Gravatar...
Interesting rumor. We run a mission critical application in a clustered environment that uses stored procedures. Works like a champ!
Left by Tara on Mar 09, 2004 8:25 PM

# re: Stored Procedure FUD

Requesting Gravatar...
Haven't heard that one yet, but I have a feeling the reason they "can't" scale is because they don't use the latest web services XML thingamajig that you can add on to your SQL Server to magically boost its performance by 200% because...it's an XML Web Service running under .Net.

(no, it doesn't actually DO anything, but hey, it's an XML Web Service and it's gonna improve your performance! Somebody said it would!)

Anyhow, it's definitely a developer who said that. :)
Left by robvolk on Mar 09, 2004 8:38 PM

# re: Stored Procedure FUD

Requesting Gravatar...
That is a beauty! High quality FUD indeed. I have heard a developer say that VIEWs don't scale!!!!
Left by DavidM on Mar 09, 2004 11:38 PM

# Take Outs for 9 March 2004

Requesting Gravatar...
You've been Taken Out! Thanks for the good post.
Left by Enjoy Every Sandwich on Mar 10, 2004 1:43 AM

# re: Stored Procedure FUD

Requesting Gravatar...
Sounds to me that the thing that doesn't scale is the intelligence of whoever said that. As their databases get bigger, their brains must actually shrink!
Left by crazyjoe on Mar 10, 2004 3:20 PM

# re: Stored Procedure FUD

Requesting Gravatar...
"Anybody who thinks that stored procedures dont scale he she is the stupid"

Classic
Left by the gigolo on Mar 11, 2004 12:11 AM

# re: Stored Procedure FUD

Requesting Gravatar...
I haven't heard that one but thanks for the good laugh. My company here before i came in said it was better to not use stored procedures in code and write the code into the application more. They had a huge push for it also. :)

Left by Pwright on Mar 15, 2004 10:34 AM

# re: Stored Procedure FUD

Requesting Gravatar...
It ain't FUD. It's misinformation. It's wrong. It's possibly a myth that has its roots in some kernel of truth from some prior point, but it ain't FUD. But I guess I wouldn't expect a crew of M$ worshippers to be able to identify FUD, since you're all so used to being fed and accepting it.
Left by Fireball on May 13, 2004 12:30 PM

# re: Stored Procedure FUD

Requesting Gravatar...
Wow

I am in awe at your credibility
Left by Damian on May 13, 2004 7:42 PM

# re: Stored Procedure FUD

Requesting Gravatar...
Heheh! this is great... I think that I may have finally found a home ;-)

My now former Employer (who shall remain nameless to protect the stupid) had a development leader (way up the food chain) that was openly against stored procedure use.

No matter how much myself and the lead database developer hammered away the benefits of stored procedures he would not listen. He kept reciting the matra "I don't want any business logic in the database!". Granted the current schema had a ton of business logic in stored procedures and a majority of it was not required, but isn't that like saying that "since some database developers have abused index views in the past that we will never use indexed views... period!" ?

I better go... I feel my rant coming on :-)

-Jim
Left by Jim on Nov 30, 2005 10:35 AM
Comments have been closed on this topic.