I'd recommend you start by finding out what your server is doing in that period of time. Take a look at Performance Recording either on your server or locally in tableau desktop to get started.
Create a Performance Recording (server)
Create a Performance Recording (desktop)
Given that you're connecting to a live datasource, you're always going to have a delay at the start as it will have to fetch something to display.
Thanks Tom. I looked around and according to this Tableau Oracle user Tableau is doing a bunch of activities in the Oracle database each time it sets up a connection. We dont have this with our MySql live database connection.
Have you done a performance recording like the one posted in the thread you're linking to?
From what I understand that is not really going to help as this has nothing to do with visualizations. Tableau is executing a series of commands to the Oracle database when it first establishes the connection. The image shows the timing issue with Tableau Server opening a new data connection from Tableau Desktop on a brand new/blank workbook I started. This happens with just the initial connections.
From what I understand that is not really going to help as this has nothing to do with visualizations.
Who said performance recording is specific to the visualizations?
I'd suggest you actually take a look at my links as a starting point before dismissing them.
Alright, I will give it a shot using Tableau Desktop. Right now the initial Tableau Server to Oracle connection was already established so the 75 second wait isn't happening. It will re-appear after some period of time with no one using the connection.
You can potentially force kill the connection on the Oracle server if this is appropriate in your environment.
If your Oracle database has a very complex schema (lots of tables and/or lots of relationships between tables) it can take some time for Tableau to "explore and discover" all this stuff when we connect.
You can use a Tableau Data Customization (TDC) file to tell Tableau no "skip" some of this activity.
(Not Oracle related, but a good post on the subject in general): Vertica Performance in Tableau & ODBC Customization | Tableau and Behold!
A site you can use to create TDCs without having to do it by hand: TDC Creator
Please contact support to help you diagnose what particular steps in the connection are slow. They can read the log files (which I don't recommend posting here) and identify the slow step.
As Russell said, on connecting Tableau will check the database for information about your connection. This shouldn't take too long, but sometimes it does. It's hard for us to anticipate all the ways someone's database might be set up, so we really need help from customers like you to see what might be going wrong.
Yes, we are working with support now trying to fix this...
And the solution was?
Hello Jason ,
It can be backend SQL query (not just connection to data-source but how are you connecting & how big your DB is ?)
I am not sure if you are using Custom SQL or Dragging tables ?
You can try running same query out of Tableau @Oracle DB , if it is taking long time to execute there as well you may need to tune the SQL query.
Tuning can be in the form of addition of INDEX , partition of Tables etc.(we work with DBA performance team) (Thats what we do since we also work with Oracle DB)
Our issue is simply getting a list of schemas/tables. It takes ~60 seconds each time we connect a particular Oracle database and we click the magnifying glass to get the list of schemas.
Once the table/view is added, extracting the data is not a problem.
2 of 2 people found this helpful
Jason S -
The delay on getting the list of schemas or tables is just your Oracle database. Tableau provides the ability to search the list (rather than returning all of them) to make it faster. You can enter the full name of the table or schema and hit + (which will skip the search entirely) or enter a substring and use the magnifying glass. You can also search by contains or starts with.