Hey Alec -
There was another thread somewhere talking about the same basic thing not too long ago. It's not unexpected for a Data Server data source to be a little slower than an embedded data source since Data Server is "another layer of stuff" that your data needs to run through.
BUT, 1 vs, 12 minutes is nuts! I'ms assuming you're pretty sure that the variability isn't Teradata - that you're not sometimes hitting it when it is "slammed" with other work...
In your shoes, here's what I'd do:
- Publish two copies of the workbook - one with an embedded data source, one with a data server data source to your Teradata db.
- When there aren't many users on the server, clear out the old logs with tabadmin cleanup --restart (this WILL restart the server to that all logs and temp files can be deleted)
- Using the browser, execute one dashboard from each of those two workbooks
- use tabadmin ziplogs MyLogs.zip to grab logs from Tableau Server
- Open up a support case
By having the logs of both a "fast" and "slow" execution of the same dashboard, Support should have everything it needs to find which part of the process is not doing what it should...BTW - please let us know what you find. This is odd.
Could you share with us a bit more about your workbook characteristics -- how many columns do you have, how large an extract (number of rows etc.) would be helpful.
Also, if you could share your performance recording from desktop and server comparing the two and can share it that would be great. If you want to send those to me 1/1 pl. email it to me at firstname.lastname@example.org
Product Manager, Tableau
1) Open the workbook from the Windows server hosting Tableau Server. This will help eliminating the issue is caused by network latency between the end user's computer and Tableau server.
2) Is live connection an absolute requirement? Keep in mind that Tableau is not a tool for live streaming and most of the time using an extract instead of live connection can improve performance dramatically. I've found that using an extract works well for 90% of my cases and you can set extract data refresh as often as every 15 minutes.
3) Have you tried tuning the OBDC connection (http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#odbc_customize.html#global_tdc ) ? We use a tdc file (attached) for our Tearadata users and it has been helpful
TeradataCapabilities.tdc.zip 422 bytes
Thanks for the suggestion. Our server is scheduled to do a cleanup --restart tonight, so after that I'll do as you suggested and open a support case.