6 Replies Latest reply on Jun 25, 2018 3:36 AM by Paulo Dantas

    Joining table with tableau desktop and the impact on response time

    Hanane Ouhammouch

      Hello folks,

       

      I have a question about joining table in tableau,

       

      I am trying to join 4 tables from the same database

       

      The database ( mysql) .

      The tables are indexed

      The big tables are partitioned

       

      The problem is that if I rely on one table with 6000000 rows for example the creation of the filter (list the values of the filter)  or the count of the id  the response time is really fast less than one minut

      When I do the same operation but with the join data source  the Execution of the query to display the filter exceeds 3 minutes with no result

       

      after checking the performance of the workbook ; the query executed in my second test case is not optimized

       

      my question is  what are the bests practice to follow to join my data in order to draw the best information

       

      and If anyone had the same problem could they share with me their experiences and what are the steps they followed

       

      thank you very much for your help

       

      Capture d’écran 2018-06-23 à 20.36.30.png