OK - it's screaming along now. I think the server is actually overkill. What was happening was at least one of the database tables was slightly corrupted, so the index wasn't working very well. It still worked, but worked much more slowly than it should have been. Now the server workload is a fraction of what it was, and the response times are great, even when I'm doing more db maintenance in the background.
|