存储过程和超时 [英] Stored Procedure and Timeout

问题描述

我正在运行一个长过程存储过程。

I'm running a long process stored procedure.

我想知道是在启动呼叫后超时还是与数据库断开连接的情况下存储过程。它仍在工作并在服务器上实施更改吗？

I'm wondering if in case of a timeout or any case of disconnection with the database after initiating the call to the stored procedure. Is it still working and implementing the changes on the server? ­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­

推荐答案

无论如何，如果客户端不在此末尾提交，

Anyway if the client is not there to commit at the end of the job the changes should be rolled back by the server.

换句话说，如果您有一个存储过程对数据库进行了更改，并且连接可能会在中间断开，请确保将所有更改包含在事务中。

In other words, if you have a stored procedure making changes to the database and there is a possibility that the connection might disconnect in the middle, be sure to enclose all changes within a transaction.

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