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