1. Stored procedure can reduced network traffic and latency,
boosting application performance.
2. Stored procedure execution plans can be reused, staying cached
in SQL Server's memory, reducing server overhead.
3. Stored procedures help promote code reuse.
4. Stored procedures can encapsulate logic. You can change stored
procedure code without affecting clients.
5. Stored procedures provide better security to your data.
No comments:
Post a Comment