Using the Performance Analyzer

You use the Performance Analyzer to improve the performance of your application by optimizing either your entire database or a single object in your database. Depending on the level of optimization you choose, the Performance Analyzer can do something as simple as adding an index to a field, or it can perform complex operations such as converting an OLE object on a form to an image.

Û To use the Performance Analyzer

1. Open the database you want to optimize.
2. On the Tools menu, point to Analyze, and then click Performance.
3. In the Object Type list, click the type of database object you want to optimize.

   

   Tip To view a list of all database objects at once, click All in the Object Type list.

4. In the Object Name list, select the database objects you want to optimize.
5. Repeat steps 3 and 4 until you’ve selected all the objects you want to optimize, and then click OK.

   In the dialog box that appears, the Analysis Results box displays a list of three kinds of optimizations: Recommendations, Suggestions, and Ideas. When you click an item in the list, the Analysis Notes box displays information about the proposed optimization. Suggestion optimizations have potential tradeoffs that you should consider before performing them. To view a description of the tradeoffs, click a Suggestion optimization in the Analysis Results box, and then read the information in the Analysis Notes box.

6. Microsoft Access can perform Recommendation and Suggestion optimizations for you. In the Analysis Results box, click each of the Recommendation or Suggestion optimizations you want performed, and then click Optimize.

   You must perform Idea optimizations yourself. To perform an Idea optimization, click that optimization, and then follow the instructions in the Analysis Notes box.