stored procedure « database « JSF Q&A

1. stored procedure for business logic, good or bad?

Any possible performance benefit is dwarfed by the downsides of not properly separating database access code from business logic. It's generally considered bad design to keep application logic in stored procedures; don't do it. Plus -and I may make incorrect assumptions here- an alumni site does not sound like something where utmost performance is needed, or where there's complex, long-running logic ...