Shipment Derived Fields - Performance Improvement

This feature provides a significant performance improvement for the set of Shipment Derived fields below.  Previously, there was a noticeable performance impact when derived fields were added to screen set results, default criteria, used while searching on finder results or used in the Enhanced Workbench.   

The set of Shipment Derived Fields below have been rearchitected for improved performance:

  • Bobtail Distance
  • Deadhead Distance
  • Total Distance
  • First Freight Equipment ID
  • First Freight Equipment Type ID
  • Number of Dropoff Stops
  • Number of NFR Stops
  • Number of Pickup Stops
  • Work Assignment ID
  • Work Assignment Sequence Number

The Shipment Derived (Calculated) fields below have NOT been rearchitected, the inclusion of any of these fields in your screen set finder or finder results will force the application to execute the legacy logic - resulting in the pervious unimproved performance:

  • Date at Driver's Next Assignment Location
  • Driver's Next Assignment Location ID
  • Destination Distance to Target Location
  • Target Location ID
  • Proximity to Driver's Next Assignment Location
  • Freight Equipment Type Assignment State
  • Pickup Duration of Driver's Next Assignment Location
  • Post-Freight Empty Equipment Type Dropoff Assignment State
  • Pre-Freight Empty Equipment Type Dropoff Assignment State
  • Pre-Freight Empty Equipment Type Pickup Assignment State
  • Primary Category Cost
  • Secondary Category Cost
  • Tertiary Category Cost

This feature provides you with a dramatic improvement in query performance for the set of Shipment Derived fields that have been rearchitected to improve query performance.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

As a precaution against any regression issues, the property  "glog.server.derived.deriveddata.improvedLoading" has been provided to, if necessary, revert to the legacy code and performance.  By default, this property is set to true to take advantage of improved performance.

If you have had performance issues in the past with screen sets that have included the derived fields below, and to address the performance issue you opted to remove the derived fields from your screen set - with the performance improvements provided with this feature, we recommend adding the derived fields back into your screen set to verify that the performance is now improved and acceptable.

  • Bobtail Distance
  • Deadhead Distance
  • Total Distance
  • First Freight Equipment ID
  • First Freight Equipment Type ID
  • Number of Dropoff Stops
  • Number of NFR Stops
  • Number of Pickup Stops
  • Work Assignment ID
  • Work Assignment Sequence Number

NOTE: The performance improvement for derived fields is currently limited to the set of 10 derived fields above, if your screen set contains any other derived fields, you will not see any performance improvements since the inclusion of any derived fields that have not been rearchitected for better performance will force the legacy query logic to be used for all the derived fields in the screen set.