VERIFIED SOLUTION i
X

Resolve slow performance in GeocodeUSAddress service with microbatching in Spectrum

Issue

When sending multiple address rows in a single request, the default GeocodeUSAddress service has poor performance.
 

Cause

The included Spectrum™ Technology Platform services like GeocodeUSAddress use a single thread to read one address row at a time from the set of input address rows. This is similar to the client application making an individual call to the service for each address row.

Resolution

UPDATED: May 19, 2017


Creating a custom service in Spectrum Technology Platform exposes settings to control the number of threads used to read address rows from the set of input address rows. For example:
  1. Open Enterprise Designer.
  2. Click File > New > Dataflow > Service.
  3. From the Palette, drag an Input, a Geocode US Address, and an Output stage onto the canvas and connect them in that order.
  4. Double click the Input stage.
  5. Select the fields to expose. AddressLine1 is the only required field.
  6. Click OK.
  7. Double click the Geocode US Address stage.
  8. Click Runtime... at the bottom of the Geocode US Address Options window.
  9. Use the slider to increase the Runtime instances: count to match the Pool size setting in Management Console for the database resource (default value: 4). The Runtime Instances setting may need to be adjusted based on performance test results.
  10. Click OK twice to return to the canvas.
  11. Double click the Output stage.
  12. Select the output fields to expose.
  13. Click OK.
  14. Click File > Save.
  15. Enter a name for the service.
  16. Select the Expose this dataflow for execution checkbox.
  17. Click OK.
This new service will use multiple threads to read address rows from the set of input address rows.  The concurrent processing will improve performance of the client application.  Review the Dataflow Designer's Guide for more information on building services.

If the issue is still not resolved, contact client support.
 

Environment Details

Operating System: Windows, Solaris, AIX, HP-UX, Red Hat, SUSE, Linux
    
Product affected: Spectrum™ Technology Platform

Versions: 10 SP1, 11 SP1, 12
 

Downloads

  • No Downloads