Koby,
When you first open AC, you will see it say, "Loading data for speed." It is bringing over most of the demographics, etc. I do not believe it brings over the scripts. So, if you have a patient with a lot of scripts and you open the chart the FIRST time, it has to the client on AC has to query the SQL database and get the scripts. That takes time. SQL should store a page or keep the meds in cache, and my guess is the second time you open it, it should be faster. Of course, on the server, the database is directly on the hard drive.
You should have three speeds:
1. The slowest speed when you right click on from the chart, you open the meds for the first time, because AC has to go all the way over and find the path to the meds and then load them.
2. If you are working in the chart, they should be loaded in cache and should be quicker.
3. Even if you close the script writer and open another chart, it should be quicker to load because SQL will have saved a "page" in the SQL memory which remembers where the query went, i.e. went to this tablet, then that column, etc.
Even on the server, once closed, reopening it should be faster due to caching and paging.
