Method R is a commonsense method for optimizing a system. It is the straightforward process of answering the four natural questions about performance: How long? Why? What if? and What else?
To answer these questions, Method R prescribes four steps:
- Identify the experience that’s the most important to you.
- Measure its response time (that’s the ‘R’ in “Method R”). In detail.
- Optimize that response time in the most economically efficient way.
- Repeat until your system is economically optimal.
Method R was first documented in the book Optimizing Oracle Performance, for which Cary Millsap and Jeff Holt were named Oracle Magazine 2004 Authors of the Year. An updated and more detailed book is available in Cary Millsap’s The Method R Guide to Mastering Oracle Trace Data.
Method R has been used with tremendous success at Oracle sites since the mid-1990s. Although Method R was first documented in an Oracle context, its usefulness extends far beyond Oracle. In fact, the definition of Method R does not refer specifically to Oracle, databases, or even computers.