Are you for or against stored procedures?.

Stored procedures have their pros and cons.

Advantages:

• Improve performance by executing code on the database side.
• Reduce traffic between the application and the database, as logic is executed within the server.
• Provide centralized management of business logic.

Disadvantages:

• Can complicate support and debugging, especially with a large number of procedures.
• Make versioning and testing more difficult.
• Tie logic to a specific DBMS, reducing portability.

I support using stored procedures when justified by performance and security requirements, but I prefer to keep business logic in the application for better manageability and testability.