Hi ,
I have a workbook connecting to ms sql server as live.It is taking almost 4 minutes to render the dashboard when we click the refresh button.
I do not have any custom sql's while connecting the dashboard.We have requirement to keep this dashboard live as it deals with real time data.
When I did the performance recording ,I see that events such as 'OTHER' or 'Building Views' or 'Computing layouts' take more timings.The execution query is taking only '161.21s' which is the highest.
Below is my dashboard which has just two static cross tab views.The percentage in the view is calculated by fixed LOD as I saw an article to reduce table calculation to increase performance.I have hidden all unused fields and deleted all unwanted calculation .However my dashboard is still taking longer time to render . What can we do to decrease timings for Other or computing layout events. The number of records to the table which the dashboard is connected to is '97K'.
Attaching the performance recording tableau workbook.Could you please help me in getting reducing overall time ? Especially for "Building view " events.
Executing query is taking only '161.2s' however building view contributes the extra seconds.Can we do anything to reduce the timings.
Regards,
Haya
Hi Haya,
How many product categories are you displaying? The amount of data you're attempting to display on the page at a single time is likely the cause of your performance issues.
I would suggest that, if you can, create a higher level roll-up of the data and allow the user to drill into the lower level.
Also, take a look at the Tableau Performance Checklist and see what areas you might be able to improve on:
https://interworks.com/blog/bfair/2015/02/23/tableau-performance-checklist
Hope this helps!
Travis
