Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] نسخه متنی

Letting the Performance Analyzer Determine Problem Areas

You can do many things to improve the performance of an application. Most of them require significant attention and expertise on your part. The Performance Analyzer is a tool that does some of that work for you. This tool analyzes the design of an Access application to suggest techniques you can use to improve the application's performance. Many of the techniques the Performance Analyzer suggests can be implemented automatically.

To use the Performance Analyzer, choose Tools, Analyze, Performance. The dialog box in Figure 17.4 appears.

Select the individual tables, queries, forms, reports, macros, modules, and relationships you want the Performance Analyzer to scrutinize. If you want Access to analyze the relationships, you must click the Current Database tab and then select Relationships. Make all your selections and click OK. When the Performance Analyzer completes the analysis process, the second part of the Performance Analyzer dialog box appears, as shown in Figure 17.5. This window provides you with a list of suggested improvements to the selected objects. The results are broken down into Recommendations, Suggestions, Ideas, and Fixed (meaning items that were automatically fixed). Suggested improvements will include enhancements such as the addition of an index or the conversion of an OLE object. After analyzing the Northwind database that ships with Access, for example, the Performance Analyzer suggested that fewer controls should be placed on the Employees form.