Optimizing Performance
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Using connection properties, you can optimize performance for your application for some
scenarios. For example, if your application accesses an Oracle database and does not need
update count information when executing batches, you can set the BatchPerformanceWorkaround
connection property to true. When set to true, the native
Oracle batch mechanism is used, which can significantly improve the performance of batch
inserts and updates because it does not return individual update counts for each statement or
parameter in the batch.