Increasing the TCP/IP request packet size may improve query response time, especially for queries transferring a large amount of data between a client and a database server process. You can set the packet size using the -p dbeng12/dbsrv12 server option, or by setting the CommBufferSize (CBSIZE) connection parameter in your connection profile.
To determine if tuning TCP/IP will help in your particular situation, conduct a performance analysis on your network using your applications before making any adjustments in a production environment.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|