1 Reply Latest reply on Jul 12, 2016 9:33 PM by Dmitry Chirkov

are multiple connections to a database faster than a single one?

Imran Akbar Jun 20, 2016 1:45 PM

If I have a workbook with 7 sheets, where each one has its own live connection to a database.

I am publishing to Tableau Server 9.2.

Is it better to join the sheets, and just use a single live connection to a database?

I know server versions after 9 will have parallel connections to a DB... but not sure whether I should expect any change in speed.

thanks

1. Re: are multiple connections to a database faster than a single one?

Dmitry Chirkov Jul 12, 2016 9:33 PM (in response to Imran Akbar)

What are you connecting to? Is there any data/relation overlap? What was the reason you went with multiple connections in the first place?

Answer is "it depends" but most likely single connection will be faster since there's less metadata querying, higher chance of hitting the cache etc.
Like Show 0 Likes(0)

Actions

Tableau Community Forums