Hey Scott -
"Your mileage may vary, but..."
Here I am running a report which would contain 12 Tabs if I used "Show Sheets as Tabs". I published the whole workbook, and simply deselected that option:
Note the very tight range for "compute view". Just under 1 second, generally. Loading/preparing the design from disk/postgress and initial rendering is taking between ~.8 sec - 2.8 sec: Median is 1.8 seconds.
Here's the exact same report published with "Show Sheets as Tabs" turned on. I'm viewing it the exact same way as I did above.
Compute time is nearly the same, which we'd expect based on tidbit I posted. But look at the difference in Load. We have a bunch up there in the 4-5 second range. Median is ~3.8 sec....so on average it's taking an extra 2 seconds (50% longer load time) in this phase.
Note that I actually restarted Tableau Server after each time I rendered the report to eliminate as much caching, etc. as I could on my numbers. In the "real world" I suspect you wouldn't see this much of a difference. For example, I just hit the "Tabbed" version again and it loaded in 2.9 seconds since I didn't force Tableau to "start from scratch", so to speak.
What is the difference between Compute View and Load View? I was unsure what "activity" was actually happening on the additional tabs that I deployed together.
In my particular circumstance, I am using a live data connection on 16 billion rows of data, so I want to ensure that I'm not running unnecessary and expensive queries in the background, but it doesn't sound as though this is part of the "activity" that goes on in the secondary tabs.
You got it -- no worries in your scenario because we don't execute "your" queries until after a user runs a specific dashboard or view. The extra time I'm warning about is "pre-work" that probably won't be very noticeable when you factor in the time it takes to run a query against so many rows.
If you opted not to "Show sheets as tabs", but have created actions to navigate from one sheet to another within a workbook, would those actions still work? For example, if I had two sheets in a workbook, one which was a summary and a second which was used to display details upon user selection and I opted not to show these sheets as tabs, would I still be able to navigate from the Summary report to the detail page with the appropriate selections applied?
No, not really. If you search the forums you'll see a few that have attempted this, and the closest they can get is launching the second sheet in a new browser window.