Hey Nick --
It's difficult to say whether this is a "cloud thing" or more a vanilla "performance thing" at this point. Can you do a little bit more testing for the group and give us additional info?
- In Tableau Desktop view each of the worksheets that are rendered in the dashboard/view that you're having problems with. How many Marks are being rendered? (You'll find this info in the lower-left hand corner of the Desktop's status bar)
- Use this information (Create a Performance Recording) to create a performance recording of your report in server. This article (Creating a #Tableau Server time machine with Performance Recorder | Tableau Love) will tell you how to permanently save/package it so you can save/post it.
- Use this information to record performance in Tableau Desktop for the same report Create a Performance Recording
- Can you put Desktop on your server box and see if connectivity behavior to SQL is the same? It may be that your server's route to the cloud is different than your machine, and this is part of the issue.
Let us know what you find.
The viz that I am using as my guineau pig is just a histogram of hourly counts - so 8-9pm, so...14 marks?
I ran the performance monitor and it pretty much said-----go to the database and fix. I did a trace on opening up that viz, and was quite amazed at all the sql going into the chart. A LOT of creating indexes, a long time creating a context table once or twice, and some lengthy time spent on selecting an if statement.
In my worksheet - Three context fields used. I made all 7 filters into context, and it did shave some time from the view load, but still not acceptable.. I guess what my issue/challenge is - how does one balance performance between a viz and a sql database? Why does Tableau have to create indexes for all of those fields - used or unused, or count distinct all those fields that I use in other worksheets but not this one? Should I have indexes on the database for all fields or..?? Question....when and what does tableau make the database do to create a viz - this one has hours as a column and count(field) for the rows....