5 Replies Latest reply on Mar 4, 2013 11:21 AM by Tony Clark

    Tableau is killing our database performance with unoptimized queries

    Imran Akbar

      We're running a MySQL database at my company, and have multiple copies of Tableau for our scientists to generate graphs of data.  It seems like every day we have people coming up to us (the software developers - as there are no DBAs) to ask us to kill slow-running Tableau queries on our database, or do something to speed things up.  We've added slave replication, added more hardware resources, but the problem seems to be that the queries Tableau is generating are not at all optimized and are resulting in the database slowing down to a crawl.  We have to look at each slow Tableau query, optimize it, and then send it back to the scientists to feed into Tableau.

       

      Is this the way it's supposed to work?

      Has anyone else had this issue?

      Is there any way to do this optimization in Tableau itself?

       

      thanks,

      imran