Stored Procedures

Difficulty: Intermediate

Question

What are the pros and cons of using Stored Procedures?

Answer

Pros: Reduced network traffic, centralized logic, security. Cons: Hard to version control, vendor lock-in, puts load on the DB instead of compute layer.

Concepts covered

Business Logic, Performance, Security