Upgraded from 5.0.0 to v5.0.1(6) running on XAMPP v3.2.2 on Windows Server 2016 and noticed in testing that it is loading patients very slowly. It will take 5-7 seconds to load a patient’s dashboards and encounters.
This shouldn’t be a hardware issue as the server VM has 4 Xeon cores and 8GB of ram and the issue only started after the upgrade.
In trouble shooting:
- Checked to make sue the sqlconf.php is the same as before.
- I took a look at my.ini and it seems fine, though I tried upping the buffer as high as 1GB without any affect on speed.
- Tried indexing all of the XAMPP folders in Windows Server.
This question may be semi relevant to the earlier post, but the issue about default buffer in my.ini seems to have been corrected: V5.0.0 too slow on Windows
I looked at the error logs in MySQL and there aren’t any related errors.
Not sure if rellevant, but in the appache logs there is the same set of errors for every patient I load:
\controllers\C_Document.class.php on line 653, referer: http://restore.emr/interface/main/tabs/main.php
[Sat Oct 20 07:37:20.679365 2018] [:error] [pid xxxx:tid xxxx] [client IP ADDRESS] PHP Warning: fopen(C:/xampp/htdocs/openemr/sites/default/documents//): failed to open stream: No such file or directory in C:\xampp\htdocs\openemr\controllers\C_Document.class.php on line 633, referer: http://restore.emr/interface/main/tabs/main.php
[Sat Oct 20 07:37:20.679365 2018] [:error] [pid xxxx:tid xxxx] [client IP ADDRESS] PHP Warning: fpassthru() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\openemr\controllers\C_Document.class.php on line 653, referer: http://restore.emr/interface/main/tabs/main.php
Any suggestions of what to look into would be greatly appreciated.