Advantages of Stored Procedures:
1) Stored porcedures separates database access logic from the application logic.
2) SQL can be pre-compiled which increases the speed of the application.
3) More processing can be done on database server due to stored procedures contain program logic, which reduces bandwidth consumed to sending data back to the application.
4) On the implementation of n-tier application, stored procedures separates the data layer from the server layer.
5) Applications can be grant execute privileges to the stored procedures, while being unable to access the tables directly. It enables security feature of stored procedure.
1) Stored porcedures separates database access logic from the application logic.
2) SQL can be pre-compiled which increases the speed of the application.
3) More processing can be done on database server due to stored procedures contain program logic, which reduces bandwidth consumed to sending data back to the application.
4) On the implementation of n-tier application, stored procedures separates the data layer from the server layer.
5) Applications can be grant execute privileges to the stored procedures, while being unable to access the tables directly. It enables security feature of stored procedure.
No comments:
Post a Comment