Good info Chi a while back I questioned AC support about going to full sql for 6.6.7 and got a lukewarm response: "could be done but should look at other issues", then version 8 came along and brought delays to another level. This info needs to be directly addressed by AC.
We will be putting out a more systemic approach to this, but the short answer to the progression after an upgrade that raises performance issues is this:
<1>Review the system, network, configuration, disk i/o, server configuration <2>64bit SQL Express upgrade - no licensing costs, labor costs for the work (FYI - we learned doing one this weekend that you need to verify that the directories are uncompressed or the un-install will lock the Microsoft software state) Another example of why our crew does this on weekends <3>Full SQL - there are cost and benefits. We always run our clients through this process before actually doing this.
Depending on several factors, practices with 10 or more computers should start with #1 BEFORE upgrading, or Physician/Provider unhappiness may ensue.
There have been some performance issues with Updox-AC scheduling syncing that hopefully will be resolved as early as this week.
As a general observation, for those moving from version 6.x this year will find that upgrading just hardware may prove frustrating.