2 Replies Latest reply on Feb 7, 2018 7:03 AM by Jeff Strauss

    best practice: workbook size for best performance?

    Ross Moffitt

      In terms of designing efficient workbooks so they perform best on the server, is there a recommended workbook size or best practice for managing large workbooks?

       

      Does it make sense to take a 25MB workbook with 5 dashboards and 30 sheets and break it down into sections, say at 5MB per workbook with 1 dashboard each- and then use URL linking on the server to cut down on load times?

       

      Just curious if anyone has implemented sizing or best practice for getting the best load times on server.

       

      Thanks!

        • 1. Re: best practice: workbook size for best performance?
          Sylvain Cogné

          Hi Ross,

           

          we had a relative similar issue on our Server regarding WB having a live Connection to an Oracle DB. So in this case, the Problem was not really the size of the WB but due to the WB design (users did not want to Change anything on this...) we had to split the number of Sheets in order to fit with the user's acceptance criteria's. One of the main differences you have between Tableau Server and Tableau Desktop is that when you open a sheet on T Desktop, it only proceed the metadata of the sheet. On T Server if the WB is published with tabbed Sheets, the full metadata have to be proceeded before Rendering... And for users it can be a no go criteria for the Performance....

           

          Otherwise, regarding your question, I do not think that a 25 MB WB Need to be splited but the question is more what would be the acceptance criteria in terme of Performance for your end user...

           

          If you look for this very usefull document : Design performant workbooks by Alan Eldridge, you will find a thousand tricks that can help you improving the Performance of your Content.

           

          I hope it will help you.

          BR

          Sylvain

          • 2. Re: best practice: workbook size for best performance?
            Jeff Strauss

            Hi Ross.  25mb for a workbook size is not overly alarming, and neither is 5 dashboards; with the caveat that you are running on a decent server with sufficient speed in terms of CPU, RAM, disk, etc.

             

            What is current rendering time?  One possible analysis tuning option is to have a look at the performance recording as this may help you identify where the bottleneck is:  Create a Performance Recording