I am extracting data from MySQL using a stored procedure (my IT guys told me this is the only option?)
The extraction takes over one hour - to refresh the same data set on the server takes 2 minutes.
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?
#1 Full refresh or incremental refresh? Are you sure you are refreshing extract and not datasource?
#2 Then you go to Data Source tab, Tableau switched back to 'live' mode and basically executes stored procedure again.