| title | Improving performance and reliability |
|---|---|
| description | Learn about various techniques for improving application performance and reliability when using the Microsoft JDBC driver for SQL Server. |
| author | David-Engel |
| ms.author | davidengel |
| ms.date | 05/19/2023 |
| ms.service | sql |
| ms.subservice | connectivity |
| ms.topic | conceptual |
[!INCLUDEDriver_JDBC_Download]
One aspect of application development that is common to all applications is the constant need to improve performance and reliability. There are many techniques to satisfy this need with the [!INCLUDEjdbcNoVersion].
The articles in this section describe various techniques for improving application performance and reliability when using the JDBC driver.
| Article | Description |
|---|---|
| Understanding timeout properties | Describes the timeouts used by the JDBC driver. |
| Closing objects when not in use | Describes the importance of closing JDBC driver objects when they're no longer needed. |
| Managing transaction size | Describes techniques for improving transaction performance. |
| Working with statements and result sets | Describes techniques for improving performance when using the Statement or ResultSet objects. |
| Using adaptive buffering | Describes an adaptive buffering feature, which is designed to retrieve any kind of large-value data without the overhead of server cursors. |
| Sparse columns | Discusses the JDBC driver's support for [!INCLUDEssNoVersion] sparse columns. |
| Prepared statement metadata caching for the JDBC driver | Discusses the techniques for improving performance with prepared statement queries. |
| Using bulk copy API for batch insert operation | Describes how to enable Bulk Copy API for batch insert operations and its benefits. |
| Not sending String parameters as Unicode | When working with CHAR, VARCHAR, and LONGVARCHAR data, users can set the connection property sendStringParametersAsUnicode to false for optimal performance gain. |