-
1. Re: Does the type of data source affect the performance?
Derrick Austin May 11, 2016 6:57 AM (in response to Kevin Monges)2 of 2 people found this helpfulHey Kevin,
It definitely does if the data is not extracted. In fact, the database setup itself can affect the performance if the data is not extracted - for example, a slow view in SQL server will perform worse than a fast view in SQL Server.
I believe Cubes, in particular, cannot be extracted (someone who uses cubes correct me if I'm wrong), so could be much slower than a static excel file.
I would recommend always extracting the data if possible.
Hope this helps!
- Derrick
-
2. Re: Does the type of data source affect the performance?
msa s May 11, 2016 7:34 AM (in response to Kevin Monges)one of the example of data source related
-
3. Re: Does the type of data source affect the performance?
Kevin Monges May 11, 2016 7:38 AM (in response to Derrick Austin)Hi Derrick,
It does make sense
Thank you very much !
Kevin
-
4. Re: Does the type of data source affect the performance?
Dmitry ChirkovMay 11, 2016 8:21 AM (in response to Kevin Monges)
What matters is:
- Data locality: local files or databases that are on you machine will be faster than something on your network or in the cloud
- Data size: obviously, less data we need to query or bring the better.
- In general Tableau doesn't move or process lot of data and this task is offloaded to database engines and yes, some databases are faster than the others
To answer your specific question: given same amount of data - cube should be faster however I find this comparison quite incorrect. Like comparing truck with carton box