SDUSize

Specifies the size in bytes of the Session Data Unit (SDU) that the driver requests when connecting to the server. The SDU is equivalent to the maximum size of database protocol packets sent across the network. This property serves only as a suggestion to the database server. The actual SDU is negotiated with the database server.

x

where:

When connecting to the server, the driver requests the specified value to be used as the maximum SDU size. While the specified value is only a suggestion, it affects the actual SDU size that is negotiated with the server.

To optimize performance, set this property based on the size of result sets returned by your application. If your application returns large result sets, set this property to the maximum SDU size configured on the database server. This reduces the total number of round trips required to return data to the client, thus improving performance. If your application returns small result sets, set this property to a size smaller than the maximum to avoid burdening your network with unnecessarily large packets.

setSDUSize

16384

int

Performance considerations