Identifying Application Performance Requirements › Determining How Often Each Entity Will Be Accessed

Determining How Often Each Entity Will Be Accessed

If you know how often each entity will be accessed, you will be able to predict potential bottlenecks in the system. To estimate how frequently each entity will be accessed:

• Review the database access path of each transaction that uses the entity.
• Analyze the frequency with which each transaction will be executed.

Sample entity access rates

The following table shows how often three sample database entities might be added, deleted, updated, or retrieved in the course of business at Commonweather Corporation.