MySQL stored procedures are programs that are not only stored, but executed on the MySQL server. They are, for the most part, logic that has been removed from the application and placed on the database server. Once called from an application over a distributed network, MySQL stored procedures provide a means of interacting in a prescribed way with the database without placing any additional traffic on the network.
Advantages of Stored Procedure
žAs alluded to above, MySQL stored procedures can greatly cut down on the amount of traffic going back and forth over your network.
žStored procedures can greatly improve the security of your database server. SQL that is executed on the server is not subject to SQL injection attacks.
žStored procedures provide a way to abstract and separate data access routines from the business logic of your application.
žStored procedures allow these routines to be accessed by programs using different platforms and API's, and make your applications more portable.
No comments:
Post a Comment