Hi, Adam, Is depth=2 necessary from the Cloud-region level? You are pulling a large subgraph with that.
Thanks, jimmy From: <[email protected]> on behalf of Adam Capparelli <[email protected]> Reply-To: "[email protected]" <[email protected]>, "[email protected]" <[email protected]> Date: Thursday, March 12, 2020 at 6:43 AM To: "[email protected]" <[email protected]> Subject: [onap-discuss] #aai #dublin AAI Queries slow down due to large relationship lists After creating about 2,000 vnf instances from a single model, AAI GET queries slowed down drastically (this is using the dublin release). Comparing the creation times in SO-monitoring, the first instance took around 2 minutes to complete, while the 1,000th took closer to 10 minutes. This slowdown was almost entirely due to querying AAI. From inspecting the logs, we saw that the GET requests that were slowing down were fetching relationship lists of increasing size as each newly created instance would be added to the next relationship list. For example, the following curl command: curl https://aai.onap:8443/aai/v15/cloud-infrastructure/cloud-regions/cloud-region/CloudOwner/RegionOne?depth=2<https://urldefense.proofpoint.com/v2/url?u=https-3A__aai.onap-3A8443_aai_v15_cloud-2Dinfrastructure_cloud-2Dregions_cloud-2Dregion_CloudOwner_RegionOne-3Fdepth-3D2&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=Oej6QUk5p2KdqNEWySpOHA&m=7TraGIqxthRdFiwPFoWL4TfVQJTnSoX1AGL50-1_MOY&s=ik04Rw2CgKtJlGJ5x0f08KVsiq2sIGQtiiga94p5iic&e=> --header 'Accept: application/json' --header 'Content-Type: application/json' --header 'X-FromAppId: robot-ete' --header 'X-TransactionId: 12345' --header 'Cache-Control: no-cache' --header 'Authorization: Basic YWFpQGFhaS5vbmFwLm9yZzpkZW1vMTIzNDU2IQ==' Returns an ~800,000 character response, of which it seems like the line-of-business-name is the only field that is needed: {"line-of-business-name":"LOB_demonstration","resource-version":"1582314838070","relationship-list":{"relationship":[{"related-to":"generic-vnf","relationship-label":"org.onap.relationships.inventory.Uses","related-link":"/aai/v15/network/generic-vnfs/generic-vnf/8ff75e52-a224-4f74-a96f-c8c270cf21a1","relationship-data":[{"relationship-key":"generic-vnf.vnf-id","relationship-value":"8ff75e52-a224-4f74-a96f-c8c270cf21a1"}],"related-to-property":[{"property-key":"generic-vnf.vnf-name","property-value":"zRegionOne4"}]},{"related-to":"generic-vnf","relationship-label":"org.onap.relationships.inventory.Uses","related-link":"/aai/v15/network/generic-vnfs/generic-vnf/0ecd3717-4307-4458-bb90-96e7c9ed1b80","relationship-data":[{"relationship-key":"generic-vnf.vnf-id","relationship-value":"0ecd3717-4307-4458-bb90-96e7c9ed1b80"}],"related-to-property":[{"property-key":"generic-vnf.vnf-name","property-value":"zRegionOne2"}]},{"related-to":"generic-vnf","relationship-label":"org.onap.relationships.inventory.Uses","related-link":"/aai/v15/network/generic-vnfs/generic-vnf/7b84833b-ccdf-4f54-b344-01bf92dc0066","relationship-data":[{"relationship-key":"generic-vnf.vnf-id","relationship-value":"7b84833b-ccdf-4f54-b344-01bf92dc0066"}],"related-to-property":[{"property-key":"generic-vnf.vnf-name","property-value":"zRegionOne8"}]},{"related-to":"generic-vnf","relationship-label":"org.onap.relationships.inventory.Uses","related-link":"/aai/v15/network/generic-vnfs/generic-vnf/c359e488-1208-4b43-afcf-b40f7f3fee0c","relationship-data":[{"relationship-key":"generic-vnf.vnf-id","relationship-value":"c359e488-1208-4b43-afcf-b40f7f3fee0c"}],"related-to-property":[{"property-key":"generic-vnf.vnf-name","property-value":"zRegionOne12"}]},{"related-to":"generic-vnf","relationship-label":"org.onap.relationships.inventory.Uses","related-link":"/aai/v15/network/generic-vnfs/generic-vnf/3aa97e89-49c7-4e9d-8267-70eaae48a6a9","relationship-data":[{"relationship-key":"generic-vnf.vnf-id","relationship-value":"3aa97e89-49c7-4e9d-8267-70eaae48a6a9"}],"related-to-property":[{"property-key":"generic-vnf.vnf-name","property-value":"zRegionOne14"}]},{"related-to":"generic-vnf","relationship-label":"org.onap.relationships.inventory.Uses","related-link":"/aai/v15/network/generic-vnfs/generic-vnf/e495ee67-3642-4a91-aaec-404970d2c08c","relationship-data":[{"relationship-key":"generic-vnf.vnf-id","relationship-value":"e495ee67-3642-4a91-aaec-404970d2c08c"}],"related-to-property":[{"property-key":"generic-vnf.vnf-name","property-value":"zRegionOne3"}]},{"related-to":"generic-vnf","relationship-label":"org.onap.relationships.inventory.Uses","related-link":"/aai/v15/network/generic-vnfs/generic-vnf/2b28d9fd-86ff-4cef-b0c0-605def227306","relationship-data":[{"relationship-key":"generic-vnf.vnf-id","relationship-value":"2b28d9fd-86ff-4cef-b0c0-605def227306"}],"related-to-property":[{"property-key":"generic-vnf.vnf-name","property-value":"zRegionOne15"}]},{"related-to":"generic-vnf","relationship-label":"org.onap.relationships.inventory.Uses","related-link":"/aai/v15/network/generic-vnfs/generic-vnf/7c31091e-1b01-400f-8a68-80184f5147ca","relationship-data":[{"relationship-key":"generic-vnf.vnf-id","relationship-value":"7c31091e-1b01-400f-8a68-80184f5147ca"}]... Has this behavior been seen before? Is there a way to exclude the relationship lists from the query? Any help or insight would be appreciated. -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#20248): https://lists.onap.org/g/onap-discuss/message/20248 Mute This Topic: https://lists.onap.org/mt/71899296/21656 Mute #aai: https://lists.onap.org/mk?hashtag=aai&subid=2740164 Mute #dublin: https://lists.onap.org/mk?hashtag=dublin&subid=2740164 Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
