There are a number of ways to optimize the performance of an application using jConnect:
Use TextPointer.sendData( ) methods to send text and image data to an Adaptive Server database. See “Updating image data in the database”.
Create precompiled PreparedStatement objects for dynamic SQL statements that are used repeatedly during a session. See “Performance tuning for prepared statements in dynamic SQL”.
Batch updates 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. See “Support for batch updates”.
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. See “LANGUAGE_CURSOR connection property” for more information.
If you use TYPE_SCROLL_INSENSITIVE result sets, only use them when the result set is reasonably small. See “Support for SCROLL_INSENSITIVE result sets in jConnect” for more information.
Additional considerations for improving performance are described below.
| Copyright © 2003. Sybase Inc. All rights reserved. |
|
|
