Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Tips for improving performance


Tip: Change packet size to improve performance

In most cases, increasing the packet size either does not affect performance or it increases performance. In some cases, performance can decrease. Increasing the packet size also increases the amount of memory used by both the client and the database server. In a production environment, conduct a performance analysis on your network using your applications before you make any adjustments.

Increasing the packet size may improve database request response times, especially for requests that transfer a large amount of data between a client and a database server. For example, an application that has many large (more than 64 KB) result sets or that transfers many large (more than 64 KB) BLOBs over very fast local networks may have a measurable performance increase by increasing the packet size from the default.

You can set the packet size by using the -p dbeng16/dbsrv16 server option, or by setting the CommBufferSize (CBSIZE) connection parameter in your connection string.

 See also