Fig. 11.1.8 A fast running transaction accessing a small amount of data.The transaction on the top is not going to be a fast-running transaction. It has too many
I/Os that it has to do. The transaction on the bottom has a much better chance of being a
fast-running transaction. It has only 1 or 2 I/Os that it must do.
Therefore, looking at the number of I/Os that a transaction must do is a good way to look
at the performance characteristics of a transaction.
There is a way to reduce the amount of I/Os that a transaction has to do.
Consider the transaction shown in Fig. 11.1.9.
Chapter 11.1: Operational Analytics: Response Time