1 Reply Latest reply on Jan 9, 2013 5:59 PM by Russell Christopher

    published data source slower than live connection

    Susan Day

      Hi

      We have 2 published dashboards - one uses a published data souce and the other uses a direct/live connection to the SQL server DB.  Using published data sources adds about 4 -5 seconds to the report refresh time compared with the direct/live connection to the database.

      It looks like this 4-5 sec overhead is static and doesn't depend on the report or amount of data in the database.

      Analysis of log files demonstrates that there are significantly more collation related activities when reports are using published data sources in comparison with direct connection.

      Does anyone know...
      1. If it is normal behaviour, that published data sources slow down report refresh times by 4-5 seconds
      2. is it related to extra collation activities
      3. Are there any ways to reduce this overhead added by usage of published data sources

      Regards

      Susan

        • 1. Re: published data source slower than live connection
          Russell Christopher

          Hey Susan -

           

          It's not out of the ordinary to see a slight hit in performance when using Data Server as it adds another "layer" that your data needs to go through:

           

          Database > Data Server on Tableau > VizQL Process on Tableau Server which renders your report

           

          ...instead of

           

          Database  > VizQL Process on Tableau Server which renders your report

           

          I recall one of our fine support folks mentioning that version 7.0.11 contains some fixes that address problems around caching and metadata about data in Data Server...so you also might want to make sure you're on the latest/greatest.