"Bogus" Millions of Instructions Per Second and User Experience Shared Memory (SHM), Local Host (LH) and Client Server (CS)
Example:
A long time ago a popular comparative benchmark was to compare how many millions of instructions per second CPUs could execute. This is still a useful metric for some purposes. In particular it is helpful when comparing single threaded performance and as a “canary in the coal mine” for misconfigured virtual machines or overloaded servers.
User experience example:
The “User Experience” metrics on the right-axis are optional and not always relevant to customer deployments. They measure the number of records that can be pulled in ~50ms and are expressed in records/second. The three flavors are shared memory, localhost client-server and remote client-server.
If the CS trend shows a sudden drop and users are experiencing slowness you may be experiencing a network issue.
The three lines demonstrate the variability of the different types of connections and may inform your decision to use a particular method of connecting your users to the database.