Improve FhirEngine Search performance for sorting about android-fhir HOT 7 CLOSED

One improvement I can think of is removing a.resourceType = b.resourceType clause in JOIN statement as we are filtering resourceType using WHERE clause. But not sure if this is feasible or even if it's gonna improve the performance

Removing this does improve the performance as well, executing the query in milliseconds cc LZRS

from android-fhir.

One improvement I can think of is removing a.resourceType = b.resourceType clause in JOIN statement as we are filtering resourceType using WHERE clause.
But not sure if this is feasible or even if it's gonna improve the performance

from android-fhir.

@aditya-07 @MJ1998 here's the ticket about the issue on performance we're experiencing

from android-fhir.

Can you tell me how does it perform without filter of active Patients ?

from android-fhir.

It is worth noting that the above latency difference is observable even on non-device sqlite db browsers like SQLiteStudio.

from android-fhir.

Can you tell me how does it perform without filter of active Patients ?

Removing the subquery that performs this filter has no impact on the performance.

from android-fhir.

thank you very much for catching this @LZRS! very happy for the improvement in @MJ1998 's pr.

just one comment for clarification and potential future work: #2553 (comment)

from android-fhir.