Optimizing Address Validation

Validate Address provides the best performance when the input records are sorted by postal code. This is because of the way the reference data is loaded in memory. Sorted input will sometimes perform several times faster than unsorted input. Since there will be some records that do not contain data in the postal code field, we recommend this sort order:

  1. Country (Only needed when processing records for multiple countries)
  2. PostalCode
  3. StateProvince
  4. City