java 存储过程 vs sql 存储过程 [英] java stored procedure vs sql stored procedure

问题描述

现在java存储过程顾名思义是用java编写的，因此它们存在于客户端.服务器上存在 SQL 存储过程.我知道使用 sql 存储过程的优点:- 我能想到的一个是减少网络开销，因为您只需发送参数而不是整个 sql 语句.

now java stored procedures are written in java as the name suggests, therefore they exists on client side. SQL stored procedures exist on the server. I know of advantages in having sql stored procedures:- One that i can think of is reduced network overheads because you only have to send the parameters instead of the whole sql statement.

但我想不出在 sql 存储过程上使用 java 存储过程有任何用处.有人可以帮我解决这个问题吗?

But i cannot think of any use of having java stored procedures over sql stored procedure . Could someone please help me on this ?

推荐答案

仅使用 Java 代码的一大优势是更易于发布和版本化.如果您使用存储过程，那么升级和回滚版本或同时运行多个版本就不是那么容易了.

One big advantage of using Java code only is that its easier to release and version. If you use stored procedures its not as easy to upgrade and roll back versions or run multiple versions concurrently.

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