Why are my REST API webservice calls taking a long time to return when using TopologyModelNameString

Document ID : KB000102463
Last Modified Date : 19/06/2018
Show Technical Document Details
Introduction:
This is a techdoc to explain why Searches (Global Collections or Locater) or Java REST API can take a long time to return if TopologyModelNameString is being used in the search or webservice call.
Question:
Why are my REST API webservice calls taking a long time to return when using TopologyModelNameString?
Environment:
Spectrum 10.2.3
Answer:
Spectrum is not optimized for TopologyModelNameString searches and this can take 40 to 60 seconds for a simple search or return from Java Webservice API.
There has been some optimization improvements made in Spectrum 10.02.03.BMP_10.2.301 which addresses this problem.

Symptom: SpectroSERVER may run into performance issue when TopologyModelNameString is used in Search queries.
Resolution: SpectroSERVER should never run into performance issues when TopologyModelNameString is used in search queries.
(DE343403, 0942135)

 
Additional Information:
If you have Spectrum 10.2.3 installed the BMP can be downloaded here:

ftp://ftp.ca.com/CAproducts/CA-SPECTRUM/Updates/GA/Spectrum_10.02.03.BMP_10.2.301/