Databases Reference
In-Depth Information
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
=
25KB (19 Network Packets)
Figure 4-12
4KB database protocol packets divided into
1500-byte network packets
Now let's look at Example B, which uses a larger database protocol packet
size.
Example B: Database Protocol Packet Size = 32KB
Using a 32KB database protocol packet, the database driver only needs
to create a single 32KB database protocol packet to send 25KB of data
to the database server (assuming a 30-byte packet header), as shown in
Figure 4-13.
=
25KB (1 Database Protocol Packet)
Figure 4-13
32KB database protocol packet size
If the MTU of the network path is 1500 bytes, as shown in Figure 4-14,
the single database protocol packet is divided into 17 network packets
for transport across the network, a reduction of 10% when compared to
Example A.
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
=
25KB (17 Network Packets)
Figure 4-14
32KB database protocol packets divided into
1500-byte network packets
