Patient data retrieval slow in OpenEmr5


#1

Retrieving patient data after clicking on patient name in patient finder window very slow when audit logging enabled, compared to OpenEmr4.2.2. Otherwise OpenEmr5 seems as fast as 4.2.2.


#2

hi @rkahn, is this on windows? thank you


#3

Windows 7 Pro 64 bit, Xenon 2.27 GHZ proc. 6 GB. 256 GB SSD, latest install of 5.0, Firefox


#4

Download the updated zip. Brady made some optimizations to the my.cnf file.
That should help​.
Alfonso


#5

Thank you but I’ve already applied these optimizations.


#6

@rkahn have you found a solution to the slowness issue with openemr 5 when logging is turned on? please let us know.

Thank you


#7

hi @rkahn and @vambati ,

Likely need to further optimize InnoDB.


(if needed, can further increase the above memory settings)

-brady