存储过程的重点是什么? [英] What's the point of a stored procedure?

问题描述

它们对数据库管理员以外的人员有用吗?如果我对它们的理解正确，那么仅仅是查询可以直接保存到MySQL中，因此任何Web开发团队都无法使用它们.

Are they useful for anything outside of a database administrator? If I understand them correctly it's merely queries that can be saved directly into MySQL, so it'd be useless for any web development team to use them.

推荐答案

存储过程是在数据库服务器上运行的 代码.

Stored procedures are code that runs on the database server.

它们有许多用途.想一想:如果我可以直接在数据库服务器上运行代码，那该怎么办呢?

They have a number of uses. Think: If I could run code directly on the database server, what could I use that for?

在它们的许多用途中，存储过程可用于将某些处理负载转移到数据库服务器，减少网络流量，和改进安全性.

Among their many uses, stored procedures can be used to shift some of the processing load to the database server, to reduce network traffic, and to improve security.

http://en.wikipedia.org/wiki/Stored_procedure

这篇关于存储过程的重点是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！