rkahn
May 10, 2017, 4:38pm
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.
hi @rkahn , is this on windows? thank you
rkahn
May 10, 2017, 7:00pm
3
Windows 7 Pro 64 bit, Xenon 2.27 GHZ proc. 6 GB. 256 GB SSD, latest install of 5.0, Firefox
Download the updated zip. Brady made some optimizations to the my.cnf file.
rkahn
May 11, 2017, 12:06am
5
Thank you but I’ve already applied these optimizations.
vambati
June 8, 2017, 4:29am
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
hi @rkahn and @vambati ,
Likely need to further optimize InnoDB.
Planned changes making on the xampp default my.ini for recording purposes:
innodb_buffer_pool_size from 16M to 256M
innodb_additional_mem_pool_size from 2M to 20M
innodb_log_file_size from 5M to 64M
An odd thing I noted but did not change is that the key_buffer is used rather than key_buffer_size (this is myisam specific, so didn’t touch this, though)
(if needed, can further increase the above memory settings)
-brady