There are many things that can be done to improve performance, but if your dashboard is only 190Mb and behaves like this, something must be seriously wrong with the app data model, or the server hosting it. Its impossible to know the reason without knowing more about your setup.
I have done 6 Gb apps that runs just fine. Its a matter of having a good datamodel with well written expressions and enough memory, disc speed and processing power on the server(s).
Robert
Svebeck Consulting AB
