Читать книгу Designing Geodatabases for Transportation - J. Allison Butler - Страница 43

The number of host database queries that must be executed mainly determines the performance of a geodatabase. Performance is generally inversely proportional to the number of feature classes being used. ESRI provides a free Geodatabase Toolset that you can use when testing the geodatabase design prior to deployment. The functions available in the Toolset include:

• Editing information

• DBMS statistics

• User information

• Versioning lineage information in a state tree diagram

• Spatial index information

• Displaying versions in the geodatabase in a hierarchical tree view structure

• Relative data fetch timer

• Refresh data timer (per layer)

• Ability to start and stop DBMS tracking

• Scripting functionality

The Toolset timers will display the time required for database operations, like fetch, draw, and label, when working with feature classes. Since transportation databases involve many more tables than most geodatabase designs, you may need to use tools that came with your RDBMS to monitor geodatabase performance more fully. Of course, the ultimate measure of effectiveness is how long it takes to do useful work under production conditions. To answer this question, you will need to do performance testing with prototypes going against a populated geodatabase that is similar in size and complexity as the production environment.