Application Performance Optimization
Analysis and resolution of critical performance issues by switching from full-load to delta-sync.
About the Project
A customer had taken over software from another software company and found significant performance issues. The mobile application – used in hospitals – needed offline functionality and thus bidirectional sync with the SAP-connected staging layer.
The problem: While the upload (little data during offline work) was performant, the download sync took over 13 seconds with every update. For power users with many orders, the app was practically unusable. The problem went unnoticed with small data volumes during development.
The analysis identified the cause: With every sync, ALL data was completely loaded (full load), regardless of whether changes were present. The developed solution implemented a delta load concept:
Once daily on first app start: Full load to ensure data consistency. For all subsequent syncs: Delta load based on an updated_at timestamp in the staging layer. Optional manual full load from within the app when needed.
Highlights
- Reduction of load time from >13s to <1s
- Root cause analysis in foreign codebase
- Conception of a robust delta load mechanism
- Minimal intervention in existing architecture
Challenges
Familiarization with acquired software. Identification of performance bottleneck.
Results
Drastic performance improvement for all users. Scalable solution for growing data base.
Interested?
Are you interested in a similar project or want to learn more? Get in touch – we look forward to hearing from you!
Get in touch
