I would like to speed up AC for my current MU pet peeve. To update the Allergies takes a long time, between 2 to 5 seconds. Not a lot to complain about, but still slow for an update query to run.
I guess most of my peeve is that it takes so much longer than the smoking combo box. Since Allergies rarely change, why can't I just check a box to confirm the allergies, rather than open the dialog box that could add a new one. But, still, it takes too long.
I have a 2 year old server with Xeon 4 processors, 20 Gb ram, Raid 10 15k HDD with adequate space, a new Cisco 500 series managed switch, and a typical client is 2 years old with E7500 duo core 2.93 GHz, 2 Gb ram and almost empty HDDs.
So my question is what should I change to get the fastest AC Allergies update?
Would I save more time with client changes such as 4 Gb ram or solid state drives, changes in the server/network, or something else? Like maybe my expectations?