Due to certain design points of ethernet, it would also severely strain the capabilities of a 100 Mbit ethernet backbone. This is most likely due to the fact that this network configuration is so fast that the difference in throughput is not a major factor in response time. If this were a low bandwidth or long geographical distance, type of connectivity, there would be a different response time result in relation to network throughput. Figure 2 When analyzing the Extra Query Block support from a network perspective, it is important to note how much the bandwidth and network is a factor in achieving your actual throughput. It is also important to note the network utilization of this support.
Many programs optimizing for many rows can severely over utilize the network.
Care must be taken to use this support carefully, perhaps only for very specific applications such as data replication. This section shows the response time and network utilization when running multiple clients. The scaling is provided by increasing the number of clients. But, due to other characteristics, networks do not scale linearly, as seen in figures 3 and 4. The maximum throughput is achieved with five clients and approximately 15.3 MBytes per second.