Hi Dileep,
I don't think an index here will help because you are not filtering on anything.
Indexes help if you are doing a lookup for a specific vertexes or set of
vertexes based on a property.
In this case, you wanted to get all the flavors in a specific cloud region.
I would suggest then to change to doing this:
GET
{aai_endpoint}/aai/{aai_version}/cloud-infrastructure/cloud-regions/cloud-region/{cloud_owner}/{cloud_region_id}/flavors/?depth=0&nodes-only=true
If you only care about the flavors and not the children underneath the flavors,
then this query will significantly improve the performance of the query.
As this query is saying get me all the flavors and only the flavors excluding
the nested children and so forth and also ignore the relationships
(nodes-only=true).
If you only care about the flavors then this will help.
Thanks,
Harish
From: Ranganathan, Dileep <[email protected]>
Sent: Friday, September 21, 2018 2:11 AM
To: FORSYTH, JAMES <[email protected]>; KAJUR, HARISH V <[email protected]>;
[email protected]
Subject: [AAI] Optimizing querying all flavors in a cloud region
Hi AAI team,
We have a use case where we need to query all flavors inside a cloud region. We
are having latency in some environments which is more than 30 seconds delay. Is
there a way we can index this and speed up performance?
GET
{aai_endpoint}/aai/{aai_version}/cloud-infrastructure/cloud-regions/cloud-region/{cloud_owner}/{cloud_region_id}/flavors/?depth=all
Is there as similar construct like <xml-property name="indexedProps" value=""/>
for ArrayList object flavors?
<java-type name="Flavors">
<xml-properties>
<xml-property name="description" value="Collection of openstack
flavors."/>
</xml-properties>
<xml-root-element name=""/>
<java-attributes>
<xml-element container-type="java.util.ArrayList"
java-attribute="flavor" name="flavor" type="inventory.aai.onap.org.v14.Flavor"/>
</java-attributes>
</java-type>
Thanks,
Dileep
-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.
View/Reply Online (#12570): https://lists.onap.org/g/onap-discuss/message/12570
Mute This Topic: https://lists.onap.org/mt/25839741/21656
Group Owner: [email protected]
Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-
