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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|