When to use stored procedures instead of using ORM with programming logic?

Question

Hi everyone, what I wanted to know when I prefer to write stored procedures for writing programming logic and pull data using ORM or something else.

Answer 1

Stored procedures are executed on the server side.

This means that processing large amounts of data does not require the transmission of this data over a network connection.

In addition, using stored procedures, you can build consistent, complex business logic.

, , , .

, ( ), SQL . .

Answer 2

SP .

• , , , :
  • ( )
• - - , Row_Delete DELETE FROM Rows .

Answer 3

.

• /
• ,
• ,

"" "".

, . , / DAL ORM, / .

, ? ?

Answer 4

, . ( )

( !) http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html

procs : http://en.wikipedia.org/wiki/Program_optimization#When_to_optimize

Answer 5

, .

, .

( , ) - , , , . .

, , , ( SP).

, .

Answer 6

, ORM, - , , . , , . ( ) ( ).