Databases Reference
In-Depth Information
maximum packet size of 64KB, the database driver must send packets of 64KB or
less. Typically, the larger the packet size, the better the performance, because
fewer packets are needed to communicate between the driver and the database.
Fewer packets means fewer network round trips to and from the database.
Note
Although most database applications experience better performance
when sending and receiving fewer packets, this is not always the case,
as explained in the section, “Configuring Packet Size,” page 92.
For example, if the database driver uses a packet size of 32KB and the data-
base server's packet size is configured for 64KB, the database server must limit its
packet size to the smaller 32KB packet size used by the driver. As shown in Fig-
ure 4-7, this increases the number of packets sent over the network to retrieve the
same amount of data to the client.
Using 64KB Packets
Driver
Using 32KB Packets
Driver
Figure 4-7
Packet size affects the number of database protocol packets
required
