CodeBetter.Com Link Blog

Sponsors

The Lounge

News

  • CodeBetter.Com Home

Advertisement

Images in this post missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at imagehelp@codebetter.com
Coding Horror: Stored Procedures vs ad-hoc SQL

Coding Horror: Stored Procedures vs ad-hoc SQL

I agree with Doug when he says the answer is "it depends." However, as I've said before, I think it's generally better to err on the side of simplicity whenever possible. Writing a bunch of mindless stored procedures to perform every database operation you think you may need is definitely not what I'd call simple. Parameterized SQL, on the other hand, really is simple. Safe and fast too. I'm certainly not ruling out the use of stored procedures, but to start with procs? That seems like a fairly extreme case of premature optimization to me.


Posted 05-18-2005 4:07 PM by Brendan Tompkins

[Advertisement]

Comments

Christopher Steen wrote Link Listing - May 22, 2005
on 05-22-2005 8:19 PM
Link Listing - May 22, 2005

Add a Comment

(required)  
(optional)
(required)  
Remember Me?