1 Reply Latest reply on Sep 16, 2016 1:07 PM by Dmitry Chirkov

    Using SQL Stored procedure with extract 750k rows of data takes more than one hour

    Kai Smith

      I am extracting data from MySQL using a stored procedure (my IT guys told me this is the only option?)

       

      Problem 1:

      The extraction takes over one hour - to refresh the same data set on the server takes 2 minutes.

       

      Problem 2:

      After the extract is complete, and I click from a chart tab back to the Data Source tab this takes another 30-40 minutes, making working with Desktop impossible.  What is Tableau Desktop doing? Why is it processing data only to view the Data Source tab?