SQL SERVER STORE PROCEDURE
-
Hello everybody, It is true that is not a good idea use store procedure actually? I mean, a) Not a good idea use it in sql and b) Using o call store procedure in a programming language? it is so: What is the best way?
-
Hello everybody, It is true that is not a good idea use store procedure actually? I mean, a) Not a good idea use it in sql and b) Using o call store procedure in a programming language? it is so: What is the best way?
No. Using stored procedures is perfectly fine, and is often preferable to embedding queries directly in your application code. Whoever told you it's not a good idea clearly doesn't know what they're talking about.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Hello everybody, It is true that is not a good idea use store procedure actually? I mean, a) Not a good idea use it in sql and b) Using o call store procedure in a programming language? it is so: What is the best way?
This is something I found some of the younger generation like to promote, put all your logic and processing in the business layer, make the database purely a storage facility. The argument is that you can spawn more processes from the BL to support growth. IMHO this is utter and absolute bullshit! Databases are optomised to support data PROCESSING as well as storage, that processing is done by stored procedures. We once did a test, I wrote a SP and a rather brilliant junior wrote a C# process to do the same long running process, the DB was dramatically faster.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
This is something I found some of the younger generation like to promote, put all your logic and processing in the business layer, make the database purely a storage facility. The argument is that you can spawn more processes from the BL to support growth. IMHO this is utter and absolute bullshit! Databases are optomised to support data PROCESSING as well as storage, that processing is done by stored procedures. We once did a test, I wrote a SP and a rather brilliant junior wrote a C# process to do the same long running process, the DB was dramatically faster.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
Mycroft Holmes wrote:
the younger generation like to promote
Where that typically means one or more of the following. 1. They are inexperienced. 2. They have no idea how to solve problems that show up 3. They have no expectation that problems will even show up. 4. They have no intention of being the one tasked with fixing the problems.
