Comment 9 for bug 1000195

No amount of hardware is going to solve problems with bad design.

These kind of queries should simply not be run on opening an application, like going to the sales module. Or should not be run at all, if hte information is needed, rewrite and redesign to get acceptabel performance, instead of hoping that throwing hardware at a problem will make it go away.

In the meantime people might be helped by the following branch, created by Akretion, that among other things allows to disable the sale dashboard:

https://code.launchpad.net/~akretion-team/+junk/addons-no-fluff