4 Replies Latest reply on Jun 13, 2018 2:06 AM by Srinivasulu a

    Performance issues when we embed the tableau charts

    Srinivasulu a

      Hi,

       

      We are embedding tableau charts in web application. It is taking minimum 20 seconds to render all the charts. Worst part is marksSelection event is taking almost 4-6 seconds to hit the event itself. Any one has faced this kind of performance issue, could you please provide any workaround for this.

       

      Thanks in advance

       

      Srini

        • 1. Re: Performance issues when we embed the tableau charts
          Mavis Liu

          Hi Srini,

           

          What kind of data source are you connecting to, is it an extract?

           

          How many filters do you have? Are they cascading (relevant values only) filters?

           

          Is  this the same issue when you open up the workbook in desktop? It might be worth opening it in desktop and going to help-> Settings and Performance -> Start Performance recording:

           

          2018-06-13_08h16_33.png

           

          Thanks,

           

          Mavis

          • 2. Re: Performance issues when we embed the tableau charts
            Srinivasulu a

            Hi Mavis,

             

            Thanks for quick response.

             

            We are connecting to SQL Server database which is a Live connection. We have 5 dashboards(In each dashboard we have min of 4 sheets and maximum of 20 sheets), but we are not displaying all at once. Based on the parameters we are displaying maximum 5 sheets in each dashboard.

             

            We have around 6 filters.

             

            In desktop it is working fine.

             

             

            Thanks,

            Srini

            • 3. Re: Performance issues when we embed the tableau charts
              Mavis Liu

              Hi Srinivasulu,

               

              In Desktop it might be fine because of caching, when someone accesses this view via web then it'll have to cache and it'll take longer.

               

              I see the live SQL database connection as one of the key reasons why it might be slower too. Have you tried making an extract and see if this will improve performance?

               

              Because your dashboards have up to 20 sheets then this will have a major impact on performance. Although your parameters are hiding these views, it'll still cause a lag because the parameters work with the filters to 'hide' certain worksheets. So the worksheets are still active on the dashboards, but they're just hidden away.

               

              If possible, some tips on improving performance based on what you've told me:

              - Instead of a live connection, use an extract and use a incremental refresh or daily refresh

              - Reduce the number of worksheets in one view

              - Reduce the number of filters and avoid using relevant filters to improve performance

               

               

              Thanks,

               

              Mavis

              • 4. Re: Performance issues when we embed the tableau charts
                Srinivasulu a

                Hi Mavis,

                 

                We need to have live connection because data will change frequently in a day. Do we have any cache concepts that we can implement Java Script API?

                 

                Thanks,

                Srini