Is there any way to speed up a view query

Hello,

Hard to say without knowing your exact system.

But something you can do is to cache the result of your query. Something like:

Regards
Tug
@tgrall