One of the reasons why SQL Server JDBC stored procedure calls are occasionally slow is "sp_sproc_columns"

In the case of CallableStatement parameter assignment or value, it is recommended to use the index number directly, avoid using the parameter name!

With the parameter name, JDBC automatically executes the exec Sp_sproc_columns stored procedure each time the stored procedure is called, obtaining the corresponding parameters for the specified stored procedure.

I don't know the exact reason, but at this time, the performance of calling the stored procedure is very unstable, from a few milliseconds to more than 10 seconds. If you know the reason for the children's shoes, please tell a sound!

One of the reasons why SQL Server JDBC stored procedure calls are occasionally slow is "sp_sproc_columns"