skip to main content
DataDirect Connect Drivers : Sybase Driver : Connection Properties : PacketSize
  
PacketSize
Purpose
Determines the number of bytes for each database protocol packet that are transferred from the database server to the client machine (Sybase refers to this packet as a network packet).
Adjusting the packet size can improve performance. The optimal value depends on the typical size of data that is inserted, updated, or returned by the application and the environment in which it is running. Typically, larger packet sizes work better for large amounts of data. For example, if an application regularly returns character values that are 10,000 characters in length, using a value of 32 (16 KB) typically results in improved performance.
Valid Values
-1 | 0 | x
where:
x
is an integer from 1 to 127.
Behavior
If set to -1, the driver uses the maximum packet size that is used by the database server.
If set to 0, the driver uses the default packet size that is used by the database server.
If set to x, the driver uses a packet size that is a multiple of 512 bytes. For example, PacketSize=8 means to set the packet size to 8 * 512 bytes (4096 bytes).
Notes
*If SSL encryption is enabled using the EncryptionMethod property, any value set for the PacketSize property is ignored.
*If your application sends queries that only retrieve small result sets, you may want to use a packet size smaller than the maximum packet size that is configured on the database server. If a result set that contains only one or two rows of data does not completely fill a larger packet, performance will not improve by setting the value to the maximum packet size.
Default
0
Data Type
int
See also
Performance Considerations