Current behavior
 
At the end of our discovery process we have 10k cmHandles from one subSystem
Each cmHandle has 162 yang resources, 7 private properties and 1 public property
 
Tried to query the cmhandles:

POST https://<ncmp_url>/ncmp/v1/ch/searches
  {
    "cmHandleQueryParameters": [
   

{       "conditionName": "hasAllModules",       "conditionParameters": [        

,
        {"moduleName": "ericsson-enm-LratEe"}
      ]
    }
  ]
  }
 
Query time in case of 57 cmHandles 24sec
Query time in case of 285 cmHandles 97sec
Query 10k cmHandles had gateway timout after 5 minutes
 

 
Expected behavior
With previous version we were able to use this searches endpoint, but with the current one it is so slow that the clients, who are calling that getting gateway timeout after 5mins on each search.
Previous version was: 
https://gerrit.onap.org/r/gitweb?p=cps.git;a=commit;h=806d31aed57c798cba0ecc33d92e5b43fa1d957b
Measurements with previous version:
   5000 cmHandles search time  2.28 sec
   7000 cmHandles search time  3.29 sec
   10000 cmHandles search time  ~5  sec
 

Maybe kieranmccarthy  could tell more about requirements, but I guess it is too slow and will cause failures in caller services. 

Reproduction

Register huge amount of cmhandles and try to search them.

In our environment it was:
  10000 cmHandles
  Each cmhandle had 162 yang resources
  Each cmhandle had 1 public property
  Each cmhandle had 7 private property

 

Try to query all of them
POST https://<ncmp_url>/ncmp/v1/ch/searches  {     "cmHandleQueryParameters": [     {       "conditionName": "hasAllModules",       "conditionParameters": [         {"moduleName": "ericsson-enm-GNBDU"},
        {"moduleName": "ericsson-enm-LratEe"}
      ]
    }
  ]
  }

CPS version

https://gerrit.onap.org/r/gitweb?p=cps.git;a=commit;h=1410509e33142c0c79ff0e111c63abc47f5936d3

Collected logs
No logs seen in NCMP