You're not providing us much to go on. First suggestion would be to use an extract as your data source.
Have you tried a few searches? Because this type of question is often asked (how to speed things up). Check out this thread, particularly Pedro's posts. Maybe you have too many data points? Maybe you have too many relevant filters?
I am using extracts optimized, hiding all unused fields.
Sorry It was a typing Mistake.
How to reduce the vizql server query limit which is by default set to 30 mins?
Anyways I have reduced the query limit to 15 mins and I see server performing in a better way.The rendering of the visualization has increased the speed on the server with almost a cut of 8 seconds.
But I would like to understand how is the reduction of query limit of vizql server is helping in increasing the performance of my dashboard on server?