I am trying to find the most optimum structure for AQL. Among the two options below, which performs better in EHRBase?
In the first, CONTAINS is defined only upto archetypes and in the second, the containment is upto ELEMENT level
{
“q”: “SELECT c1/uid/value as compositionId,c2/activities[at0001]/description[at0002]/items[at0070]/uid/value as uid, c2/activities[at0001]/description[at0002]/items[at0070]/links/target/value as link FROM EHR e[ehr_id/value =‘18af7da5-46fc-4cf6-9078-34c1261a3368’] CONTAINS COMPOSITION c1 CONTAINS INSTRUCTION c2[openEHR-EHR-INSTRUCTION.medication_order.v3] WHERE c2/activities[at0001]/description[at0002]/items[at0070]/links/target/value= ‘ehr://18af7da5-46fc-4cf6-9078-34c1261a3368/compositions/818d58e1-af0d-4192-8be8-b7beef5bd074/5b9e74bd-4a7c-4851-b1fb-73260d7dc7dc’”
}
{
“q”: “SELECT c1/uid/value as compositionId, i/uid/value as uid, i/links/target/value as link FROM EHR e[ehr_id/value =‘18af7da5-46fc-4cf6-9078-34c1261a3368’] CONTAINS COMPOSITION c1 CONTAINS INSTRUCTION c2[openEHR-EHR-INSTRUCTION.medication_order.v3] CONTAINS ELEMENT i WHERE i/links/target/value = ‘ehr://18af7da5-46fc-4cf6-9078-34c1261a3368/compositions/818d58e1-af0d-4192-8be8-b7beef5bd074/5b9e74bd-4a7c-4851-b1fb-73260d7dc7dc’”
}