These connection properties have been added or modified to improve jConnect performance:
DYNAMIC_PREPARE – when set to true, DYNAMIC_PREPARE enables you to precompile dynamic SQL statements. The default value of this property has been changed to true, because, in most cases, this setting improves jConnect performance.
However, you cannot use the prepare command to precompile all SQL statements. For such SQL statements, Sybase recommends that you do not use PreparedStatement, and to set DYNAMIC_PREPARE to false to avoid unnecessary precompilation attempts. For more information about DYNAMIC_PREPARE, and the advantages and disadvantages of using prepared statements, see the jConnect for JDBC Programmers Reference.
IGNORE_WARNINGS – specifies whether or not to check for and generate warning messages. Currently, this property checks only for warning regarding the loss of precision when storing timestamp values into Adaptive Server date and time datatypes, which have lower precision than the Java timestamp.
Valid values:
True – jConnect does not check for and generate warning messages, thus improving performance.
False – the default value, which directs jConnect to check and generate warning messages.
OPTIMIZE_FOR_PERFORMANCE – specifies whether or not to enable jConnect performance enhancing properties. Currently, this property controls only the IGNORE_WARNINGS property.
Valid values:
True – jConnect runs in enhanced performance mode.
False – the default value, which means that jConnect runs in normal mode.
Before setting IGNORE_WARNINGS or OPTIMIZE_FOR_PERFORMANCE to true, thoroughly test the impact of such a configuration on your application.