Void setEnablePrepareOnFirstPreparedStatementCall(boolean enablePrepareOnFirstPreparedStatementCall) If the setting is 1, these calls are batched together to avoid overhead of calling sp_unprepare too often. This setting controls how many outstanding discard actions ( sp_unprepare) there can be per connection before a call to clean up the outstanding handles on the server is executed. Specifies the behavior for a specific connection instance. Void setServerPreparedStatementDiscardThreshold(int value) The default for this option can be changed by calling getDefaultServerPreparedStatementDiscardThreshold(). If the setting is } 1, these calls are batched together to avoid the overhead of calling sp_unprepare too often. Returns the behavior for a specific connection instance. Int getServerPreparedStatementDiscardThreshold() This behavior relieves the need for sp_unprepare on prepared statement close if the statement is only executed once. If a second execution happens, it calls sp_prepare or sp_prepexec and actually sets up a prepared statement handle. If the value is false, the first execution calls sp_executesql and doesn't prepare a statement. Void setEnablePrepareOnFirstPreparedStatementCall(boolean value) The default for this option can be changed by calling setDefaultEnablePrepareOnFirstPreparedStatementCall(). If false, the first execution calls sp_executesql and doesn't prepare a statement.
Void closeUnreferencedPreparedStatementHandles()įorces the unprepare requests for any outstanding discarded prepared statements to be executed.īoolean getEnablePrepareOnFirstPreparedStatementCall()
Returns the number of currently outstanding unprepare actions. Int getDiscardedServerPreparedStatementCount() SetEnablePrepareOnFirstPreparedStatementCall(boolean value) List of the new APIs introduced with this change, for batching of unprepare for prepared statements SQLServerConnection New Method Users can change the default behavior to the previous versions of always calling sp_prepexec by setting enablePrepareOnFirstPreparedStatementCall to true using the following method:
0 kommentar(er)
