1 Reply Latest reply on Jan 30, 2014 6:27 AM by Matt Lutton

    Tableau 8.1 taking a long time to display report

    Gautam S

      Hello Everyone,

       

      I have a stored procedure as a source connection in Tableau 8.1. It takes a long time to fetch and display ( about 1 min) 40000 records (there is no bar chart, pie charts etc). What the stored proc does is it selects 40000 records with some 6-7 table joins. However the same stored procedures executes and displays the records in sql server management studio within 3 seconds. 

      After using SQL Server Profiler, it shows that some 45000 inserts into a tableau temp table occurs which takes a long time. Also, it shows in the log file that it takes a high percentage of time for the inserts while the execution of stored proc itself takes about 4-5 seconds only.Is this the problem ?Any suggestion how to over come this issue?

      Regards Gautam S have a stored procedure as a source connection in Tableau 8.1. It takes a long time to fetch and display ( about 1 min) 40000 records (there is no bar chart, pie charts etc). What the stored proc does is it selects 40000 records with some 6-7 table joins. However the same stored procedures executes and displays the records in sql server management studio within 3 seconds.

      After using SQL Server Profiler, it shows that some 45000 inserts into a tableau temp table occurs which takes a long time. Also, it shows in the log file that it takes a high percentage of time for the inserts while the execution of stored proc itself takes about 4-5 seconds only.Is this the problem ?Any suggestion how to over come this issue?

       

       

      Regards

      Gautam