![]() To use the Sybase native batch mechanism, this property should be set to true.ĭata encryption may adversely affect performance because of the additional overhead (mainly CPU usage) required to encrypt and decrypt data. The JDBC 3.0-compliant mechanism returns individual update counts for each statement or parameter set in the batch as required by the JDBC 3.0 specification. In addition, if the batch contained a statement that called a stored procedure or executed a trigger, multiple update counts for each batch statement or parameter set are generated. When using the native mechanism, be aware that if the execution of the batch results in an error, the driver cannot determine which statement in the batch caused the error. Performance can be improved by using the native Sybase batch environment, especially when performance-expensive network roundtrips are an issue. The driver can use a JDBC 3.0-compliant batch mechanism or the native Sybase batch mechanism to execute batch operations.
0 Comments
Leave a Reply. |