Review the options to optimize the performance of an application using jConnect.
Use TextPointer.sendData methods to send text and image data to an Adaptive Server database.
Create precompiled PreparedStatement objects for dynamic SQL statements that are used repeatedly during a session.
Use batch updates to improve performance by reducing network traffic; specifically, all queries are sent to the server in one group and all responses returned to the client are sent in one group.
For sessions that are likely to move image data, large row sets, and lengthy text data, use the PACKETSIZE connection property to set the maximum feasible packet size.
For TDS-tunneled HTTP, set the maximum TDS packet size and configure your Web server to support the HTTP1.1 keep-alive feature. Also, set the SkipDoneProc servlet argument to true.
Use protocol cursors, the default setting of the LANGUAGE_CURSOR connection property.
If you use TYPE_SCROLL_INSENSITIVE result sets, use them only when the result set is reasonably small.