Specifies the Session Data Unit (SDU) that the driver requests when connecting to the server. The SDU is equivalent to the maximum packet size (size of database protocol packets sent across the network). This property serves only as a suggestion to the database server. The actual SDU that is used is negotiated with the database server.
This property is mutually exclusive with the TNSNamesFile and TNSServerName properties. The driver generates an exception if SDUSize is specified in conjunction with either of these properties.
Valid Values
x
where:
x
is an integer from 512 and 32767.
Behavior
If set to x, the driver sets the SDU to the specified size. For optimal performance, set this option to the maximum SDU size configured on the database server.
Notes
If your application sends queries that only retrieve small result sets, you may want to use an SDU size smaller than the maximum SDU size 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 SDU size.