Data performance tips

Proper tuning of the database and the implementation of attribute and spatial indexes during the data loading operation will enhance the performance of any application, This is especially true for Esri Roads and Highways because of the extensive data processing steps involved.

To get optimal performance from mapping events in Roads and Highways, please ensure that your database has the appropriate indexes created:

Table Name

Multicolumn attribute index fields

Route

Route ID column or columns if a multi-field Route ID

Calibration Point feature class

Route ID, NetworkID, From Date, and To Date

Centerline feature class

RoadwayIDGUID, From Date, and To Date

Centerline Sequence

Route ID, NetworkID, From Date, To Date, and RoadwayIDGUID

Event

  1. Route ID, EventID, From Date, and To Date for map navigation
  2. Route ID, EventID, FromDate, ToDate, and Measure (for point event) or FromMeasure and ToMeasure (for line events) for LRS editing workflows

Since the calibration point and centerline feature class are stored in a geodatabase, spatial indexes are automatically created and maintained for you. In some circumstances, recalculating a spatial index may improve performance, as described in Modifying a spatial index.


12/19/2012