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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » SQL Anywhere database connections » Troubleshooting connections


TCP/IP performance

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.

 See also