Performance and Tuning

Review the instructions to fine-tune or improve performance when working with jConnect.

Improve jConnect performance
Review the options to optimize the performance of an application using jConnect.
Performance Tuning for Prepared Statements in Dynamic SQL
In Embedded SQL™, dynamic statements are SQL statements that need to be compiled at runtime, rather than statically.
Cursor Performance
When you use the Statement.setCursorName method or the setFetchSize( ) method in the SybCursorResultSet class, jConnect creates a cursor in the database.

Created June 6, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com