2 Replies Latest reply on Feb 29, 2012 10:53 AM by Dan Cory

    time taken by queries in mysql database (without tableau connection) is much less than when connected through tableau



      we are using mysql 5.0.92 and connecting tableau 7.0 desktop client to it.

      Surprisingly, the queries that take 5 secs to run inside our mysql database without connection with Tableau, those exact same queries take 20 mins or more to run when fired as a datasource in tableau.

      I do not know what I am missing, if it is a problem with the query performance, like missing proper indexes or something, the query should have taken the same long time to execute in mysql database.

      Any help will be appreciated in this regards.