Dear ObjectDB Support Team,
I hope this email finds you well. I am Dr M H B Ariyaratne, the Acting Consultant in Health Informatics at the Health Information Unit, Ministry of Health, Sri Lanka. I am writing to seek your urgent assistance regarding performance issues we are facing after migrating our Cloud HIMS application to ObjectDB.
Application: Cloud HIMS is a JSF/JPA (EclipseLink 2.3)/MySQL application used to capture data in Health Care Centres across the country.
Database Size: Our MySQL database was 66GB in size before migration.
Migration Status: We are halfway through transferring data. Metadata, Patient Data, and Encounter Data have been migrated. Observations are still being migrated.
Current Issue: Despite the migration, we have not seen any improvement in performance.
Server and Configuration Details:
Server: The VM is running on Ubuntu 20.04 with 70GB RAM. No other major processes are running.
ObjectDB Configuration: I have attached the configuration files and server.sh file for your reference.
Resource Usage: I have also attached snapshots showing the usage of resources like RAM and CPUs.
We have taken several steps to improve performance, including indexing, query optimization, and server resource allocation, but the issues persist.
Could you please assist us in identifying the cause of these performance issues and suggest any possible solutions?
Thank you for your time and assistance.
Best regards, Dr M H B Ariyaratne Acting Consultant in Health Informatics Health Information Unit, Ministry of Health, Sri Lanka
- ObjectDB Configuration Files
- Server.sh File
- Resource Usage Snapshots