OpenEMR load-time taking few seconds for a patient record retrieved through the API

OpenEMR Development
#1

Hi community, We are experiencing slow performance on OpenEMR, the load-time is taking a few seconds for a patient record retrieved through the API.

Has anyone come across this and is familiar with potential issues and resolutions?

#2

How many records are you dealing with, what version of OpenEMR are you running, what are you using for your DB backend. We need more details to offer support.

If you are on MySQL run a ‘SHOW PROCESSLIST’ while you are hitting the API and you can see what query may be running slow on your box. Enabling slow query logs can also illuminate the issue for you.

#3

Hi Stephen,

Thanks for your response.

We are running OpenEMR v7. There are no records in the database, as we haven’t gone live. We are testing in the staging environment. Are there any known issues (e.g. missing indexes ) that would explain the slow response on a fresh database? We will try to log query execution at our end also to dig out but if you can think of any obvious issues, please share.