@stephenwaite I respect your opinion. My concern before just adding resources is that I have a larger system with 6 times the data running on the same type server with out any slowness. How is that possible?
It is a mystery I am trying to solve. They both have data that was converted from v4. One has 1.2GB of data (phpmyadmin stats). The other has 6.7GB of data in the database. But the one with 6GB of data runs faster than the one with 1.2GB of data.
We did test the 1.2GB system and when we put in a new patient the patient chart pops up faster than some of the existing patients charts. So, it is about the data contained within the charts. In the 1.2GB system they store lots of EOB files in the chart. I don’t know what effect that has on the system. When I say a lot, there could be over 30 -50 EOB files in the chart.
I am going to keep digging.
I did limit the past encounter drop down to 15 most resent past encounters. But the system still take up to 30 sec to load that client that has 159 past encounters. I have limited the document display in the encounter tab to the 5. The chart still takes 30 to load.