Why do you requery the whole view why not just pull info necessary. Indexing will also help. Have you checked your network traffic? It will never be as fast as a local table. You should also check the hardware for your sql server to make sure that a hardware upgrade would not help.

Matt