Two questions relating to speed and memory use:
1. I am confused about Neurodawg's statement above. Does the amount of memory used by SQL server correlate with speed (i.e. higher memory used means slower speed)?
2. I am running AC on a peer-to-peer using as the "server" a Dell Vostro 220s with a Core2duo processor and 3MB of RAM. This has worked beautifully running AC V6.3.3. I am thinking of finally upgrading; will probably go to V8, skipping all the versions in between. A goal is to maintain the current speed of running the program. I realize that I will need to upgrade this machine (but hopefully not the clients, which are i3's and i5's). Would a Dell XPS 8700 with an i7 processor and 8GB of memory do the job?