ArcMap

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 Pipeline Referencing because of the extensive data processing steps involved.

To get optimal performance from mapping events in Location Referencing for Pipelines, please ensure that your database has the appropriate indexes created.

Table nameMulticolumn attribute index fields

LRS Network feature class

  1. RouteID
  2. From Date
  3. To Date
  4. Route Name (if configured)
  5. Line ID (if configured)
  6. Line Name (if configured)

Calibration Point feature class

  1. Route ID
  2. Network ID
  3. From Date
  4. To Date

Centerline feature class

  1. Centerline ID

Centerline Sequence table

  1. Route ID
  2. Network ID
  3. From Date
  4. To Date
  5. Centerline ID

Lookup table

  1. Key Field
  2. Display Field (if lookup table is configured with this field)

Event feature class

  1. Event ID
  2. Route ID
  3. To Route ID (if configured)
  4. From Date, To Date

Intersection feature class

  1. Route ID
  2. From Date
  3. To Date

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 Rebuild a spatial index.