Patient Finder slow

Support
1

Patient Finder slow (greater than 20 seconds) to return previous encounter list for patient with many previous encounters (greater than 50).

OpenEMR Version
I’m using OpenEMR version 7.01

Browser:
I’m using:

Operating System
I’m using: Ubuntu 22.04

Search
Did you search the forum for similar questions?

Logs
Did you check the logs?
Was there anything pertinent in them?
Please paste them here (surround with three backticks (```) for readability.
You can also turn on User Debugging under Administration->Globals->Logging User Debugging Options=>All

1 Like
2

Lot of possibilities to consider here.
Check apache2 error log and sql error log.
If you haven’t already, enable slow query logging in MariaDB/MySQL and set it to catch everything that exceeds 10 seconds.
If you have large numbers of patients, and also large numbers of encounters per patient, make sure that you’ve adjusted your database daemon configuration to provide adequate resources for the SQL server.
The default config files that come with the SQL packages on linux distros are woefully inadequate for production use as an EMR back end.

2 Likes
3

Thanks. Increasing maximum memory in my php settings gave me a substantial speed boost. I’m now trying to see if I can optimize MariaDB. My setup is a relatively simple case as the practice is one doc who is the usually the sole user. We currently run a separate application to manage the practice and use OpenEmr solely for charts.