1 Reply Latest reply on Jun 26, 2012 2:42 PM by Russell Christopher

    Refreshing Dashboard Performance (using a Parameter)

      I am trying to understand what I have in my workbook and Tableau is actually doing behind the scenes that is so negatively impacting the refresh performance in my dashboard.   What I am looking at is the adverse performance I have when I change a single parameter on my dashboard.   I have isolated the performance in the Tableau log (see below).   Notice that steps from the first line to the 2nd to last line take 54 secs, whereas whatever occurs between the 2nd to last line and the last line takes nearly an additional 2 minutes.

       

      ================================================= snip ================================================

       

      2012-06-26 10:14:58.843 (0db8): ---------------------------------------------------------

      2012-06-26 10:14:58.843 (0db8): Update sheet 'XXXXX'

      2012-06-26 10:14:58.843 (0db8): ---------------------------------------------------------

      2012-06-26 10:14:58.858 (1104):

      2012-06-26 10:14:58.858 (1104):

      2012-06-26 10:14:58.858 (1104): ---------------------------------------------------------

      2012-06-26 10:14:58.858 (1104): Data interpreter is instancing a specification

      2012-06-26 10:14:58.858 (1104): ---------------------------------------------------------

      2012-06-26 10:15:01.561 (1104): DATA INTERPRETER: Executing primary query.

      2012-06-26 10:15:03.280 (1104): <QUERY protocol='05e8be70' session_id='1'>

      ...

      2012-06-26 10:15:52.107 (0db8):     [Time] Computing the filter state took 23.346 sec.

      2012-06-26 10:15:52.107 (0db8):    [Time] 23.388 sec. for QuickFiltersController::UpdateAll

      2012-06-26 10:17:48.979 (0db8): Finished rendering sheet: XXXXX

       

      ============================================end of  snip ================================================

       

      The dashboard that experienced this performance contains only a single worksheet; however the entire workbook contains 4 dashboards and 17 worksheets.

       

      So I culled out the dashboard and single worksheet in question above into a separate Tableau workbook and repeated the performance test (i.e., change a single parameter only after loading), and got differing performance results. 

       

      ================================================= snip ================================================

       

      2012-06-26 10:19:45.210 (0d44): ---------------------------------------------------------

      2012-06-26 10:19:45.210 (0d44): Update sheet 'XXXXX'

      2012-06-26 10:19:45.210 (0d44): ---------------------------------------------------------

      2012-06-26 10:19:45.226 (0ad0):

      2012-06-26 10:19:45.226 (0ad0):

      2012-06-26 10:19:45.226 (0ad0): ---------------------------------------------------------

      2012-06-26 10:19:45.226 (0ad0): Data interpreter is instancing a specification

      2012-06-26 10:19:45.226 (0ad0): ---------------------------------------------------------

      2012-06-26 10:19:47.819 (0ad0): DATA INTERPRETER: Executing primary query.

      2012-06-26 10:19:49.413 (0ad0): <QUERY protocol='073a2de0' session_id='1'>

      ...

      2012-06-26 10:20:36.584 (0d44):    [Time] 22.382 sec. for QuickFiltersController::UpdateAll

      2012-06-26 10:20:45.896 (0d44): Finished rendering sheet: XXXXX

       

      ============================================end of  snip ================================================

       

      Notice that the time required to update the sheet (1st line to 2nd to last line) was approximately the same as the time that it took for the Tableau workbook that contained all dashboards/sheets, however, the time required to render the sheet (or whatever else Tableau is doing but not telling the user in the log) took 9 secs only!!!

       

      So in order for me to identify what is causing my performance issue with my dashboard, I need to know what it is that Tableau is doing between the last two steps.  The Tableau log is not being very transparent as to what it is doing behind the scenes.... In both cases, the dashboard/worksheet in question is precisely the same.  The only thing that is different between the two tests is that I culled out all of the non-essential worksheets and dashboards out of the workbook to include only the single dashboard and worksheet.  

       

      Does anyone know Tableau is actually doing between the last line and the 2nd last line???   Is the fact that I am using parameter(s) the cause of performance issue (i.e., between the last two lines)? 

       

      I am running Tableau 7.0.5 and using a TDE in both cases.

       

      Thanks in advance for any/all advice/feedback...