Comments (7)
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.
@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.
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.
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.
Related Issues (20)
- Sync upload local changes reordering patch issue HOT 7
- Deploy pre-built SNAPSHOT pre-release (dev, unstable) versions of Engine and DataCapture to a Maven repo HOT 7
- Configurable hyphen("-") answer option in dropdown menu. HOT 3
- Speed up initially processing questionnaireStateFlow HOT 1
- Date Picker Constraint Not Enforced on 'Ok' Button Click. HOT 6
- Fix case when we purge a resource with forcePurge and related resource in LocalChange HOT 1
- Several records of resources with same resource Id returned leading to duplication HOT 9
- Troubleshooting failing Kokoro CI checks HOT 1
- Previous button invisible when launched in review mode HOT 3
- Demo app crashes with ServerConfiguration is not provided HOT 1
- Improve initial load for calculated-expression HOT 1
- Open choice missing string value HOT 5
- Improve Readability and Maintainability of Data Purge Function (purge()) HOT 1
- Expose an interface to db.withtransaction through FhirEngine
- Do you think it would be important to handle [WorkInfo.State#BLOCKED](https://developer.android.com/reference/androidx/work/WorkInfo.State#BLOCKED) status or defaulting to error would just be enough?
- support for UploadRequestGeneratorMode.UrlRequest in UploadStrategy (?) to support OpenMRS as FHIR Backend HOT 1
- refactor - Move Search Logic from Search.execute() to FhirEngine.search() HOT 2
- erroreneous docs - search method documentation
- 'SELECT' queries sometimes take too long to run HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from android-fhir.