Incomplete times in schedule
is there a report to find uncompleted visits in the appointment scheduler?
rather than loading each page day by day and completing the incomplete entries
worklists are regularly checked, but im still finding items waiting for 00-0000hours
or maybe limit the access to workflow page?
basically we were not checking out properly and there are lots of incomplete or open visits on the scheduler, i presume this is the reason the workflow schedule page is slow to load, while client and patient details load quickly
the incomplete report works well for the patient visits, i hoping there was something similar to speed up workflow access
Re: Incomplete times in schedule
Humm - we should clarify some things. The appointment, the task (worklist entry) and the patient visit all have statuses. Are you looking for incomplete patient visits or incomplete appointments?
However, note that the status is not an 'index' in the acts file - hence reducing the number of incomplete appointments will not speed up the appointments screen.
Q1. What OpenVPMS version are you running - I seem to remember that 1.8 included some tweaks to improve the appointments screen display times.
Q2. Has anyone looked at your system setup - ie how much memory does MySQL have for caching data? [On a machine with 16GB of RAM we give 9 GB to MySQL]
Regards, Tim G
PS - If I look at yesterday's appointments on the system in Hong Kong, I can see that around a quarter are not complete. This is partly because the 'block off' appointments we use are all in Pending status, but also because of incorrect workflow practices - the classic one being, on check-in, pressing the Red X at the top right of the Patients|Medical Records screen rather than OK.
Re: Incomplete times in schedule
incomplete patient visits i run the report to fix those. since i have started manually finalizing open visits the speed of the system has improved, just not on the appointment schedule
incomplete appointments - when the page finally opens and it might say waiting for x00 hours
im running Version 1.7 on a windows machine
i agree about the check in check out process, im trying to get all the staff to change to the 3c's protocol, but old habits are hard to break
caching data might well be the issue, i will have to see what the system is set at, however i do that
i have had a computer company look at the system, all they told me was the computer wasn't using all the memory and i had to upgrade to a new server to fix the problem.
i set up the system myself. the issue started as the database has got larger the backups are now about 800mb
the computer system speed is fairly reasonable after a server restart, but gradually gets slower the more files/histories we access, then i have to restart the server to move faster than snail pace
Re: Incomplete times in schedule
Humm - I don't like the "computer wasn't using all the memory and i had to upgrade to a new server to fix the problem".
Can you start the Task manager (either press Ctrl-Alt-Del and select the Task Manager or right click on the Task Bar at the bottom in an empty space and left click the Task Manager).
If it looks something like this
then click the "More details" at the bottom.
Click its performance tab and tell me what it says for Memory usage. My development machine (running Win 8) shows:
If this was a production system, I would be concerned that I had 5.2GB of available memory that I could give to MySQL but hadn't.
Now click the Processes tab, and then click the Memory column header to make it sort on most to least memory usage.
I would hope that mysqld.exe is at the top. Tell me what its % is.
[Note that although it is the biggest memory user in my development system, I still have 5.2GB spare. As I said, if this was a production machine I give this to MySQL - but seeing its a development system I keep spare memory for other programs I use.]
So if you do not have much spare memory, do you have to buy a new server machine? Not necessarily - ask your computer person if the machine can have more memory added to it - adding memory is the cheapest way to add more performance to most machines. ie if you have an 8GB machine, you should be able to expand it to 16GB.
If you do have spare memory, how do we add it to MySQL?
What we need to do is to find the MySQL configuration file and adjust it.
To find the file, we need to fire up the Services manager. Either use Start|Control Panel|Administartive Tools|Services, or type 'services' into the search programs and files box.
This will look something like:
Scroll the display down until you find MySQL and then right click on it and then left click on Properties and you should get something like the following:
[NOTE - depending on how it was installed your MySQl may be called MySQL55 or MySQL51 or something else starting with MySQL]
Left click in the 'Path to executable' line, and then press the End button to scroll the data display to the right - you should see something like:
So now we know that the default file is (in my case) in the "c:\program files\mysql\mysql server 5.5" folder and is called my.ini
Use Notepad (or any other text editor) to open this file and look for innodb_buffer_pool_size - here is mine:
A # at the beginning of the line makes it a comment. So you can see that the setting started off at 107M - then I increased it to 1600M and finally to 3200M (ie 3.2GB) - the current setting.
If I wanted to use up say 4GB of my spare 5.2GB I would change the 3200M to 7200M.
Now save the file. You will almost certainly find that Notepad bitches saying that it cannot save the file - this is because you are normally not allowed to write to the C:\Program Files folders. If this happens, save the file somewhere you can write to (eg your downloads folder) - then use Windows Explorer to copy the file back to the MySQL program folder - eg "c:\program files\mysql\mysql server 5.5" in my case. Explorer will say that you need admin priveleges to do this - tell it to go ahead.
Now all we need to do is restart MySQL - so back to the Services program, and click the blue Restart link for MySQL. [First making sure that nobody else is using OpenVPMS.]
If you go back to the task manager you should see MySQL using more memory and that you have less unused.
Hope this helps, Regards, Tim G