Wow. That would be so great. Last week it took, as I said, in the neighborhood of a minute to open Imported items on a patient. Then maybe 20 seconds to open a particular lab. Then another 45 seconds or so while the imported items reloaded before I could select at another lab. And that was not my benchmark patient with the huge number of INR's and other labs; just someone with hepatitis C under treatment getting normal labs. You can imagine how frustrating this is. I have to write down the first set of lab values manually before trying for the second as I cannot be certain to remember all the values in between data loads.
David, we have talked offline about your network before, and I came away from the conversation with the impression that it was getting the switches upgraded and would be reliable and reasonably fast.
That said, my experience is group practices above 20-30 connections to the database, AC (in part because of the SQL Express limits) starts to get memory then I/O bound.
One partial fix is running a full version of SQL Server, the other would be faster disk, ala SSD RAID.
We regularly onboard practices with 10-20G of II, we are doing one now with 80G; I only asked about size to know what it would take to fully restore your DB.
Try the same patient tomorrow a few times as more people get logged in and see what results you get.
