Upgraded the machine to Windows 7, clean install, with no other hype, just AC.
Although the entire machine is slower now, pulling pharmacies and eRX is faster. Of course this is just with AC running, no other applications, and I turned off a lot of windows running services. -- I think I have to go buy a new PC now, just to handle AC.. fun fun.
I haven't done any hard programming for years now, but I do believe the problem is Crystal Reports. With the amount of data in the tables, coding SQL statements will take programmers a lot longer to do. SQL is database specific and the dialect can be tricky, but the speed increase will be substantial.. I have built a reporting COM object, back in the day, for generating reports and creating data views based on user selection, and never ran into speed issues. ( I don't claim to be an expert, and have been out of developing for years, fyi. ) Maybe AC doesn't have a DB developer?
-- I do agree that more emphasis needs to be made on what AC does right now, i.e. fixing bugs, speed, and making it more solid vs. the fast push to get a PM out..
"Jack of all trades, but a master of none", will be AC's fate..
just my 2 cents..
