1. Change to 1Gb/s. Need Gb switch and Cat5e to Cat6 cable and Gb NICs.
2. Completely turn off all other computers and see your speed.
3. Consider using a 64-bit server OS and up your RAM to at least 8GB of RAM. I would go with 12.
4. Why the other EMR database? That seems confusing. Is it using SQL? What does Medisoft use? Turn these services off and see what happens.
5. Doubtful, but with all those databases, your bandwidth is not enough, hence the Gb/s. You can try one computer and if it is still 80 seconds, make it Gb/s. You can probably get a small Linksys with Gb capacity and a cheap NIC card.
6. Are you on a domain or P2P?
7. Do you mean mbps or Mbps? I am guessing the latter.
8. The key is to turn off ALL machines but one, then try that machine. If successful, turn one machine on at a time.
9. The fact tha it runs fast on the server proves it a network problem. 99% of these issues are due to network issues.
10. If still having issues, get a crossover cable and connect directly to the server.