Optimize my extract?  How do I do that?

I'll look into the possibility of doing the conversion as part of the SQL call with our database guy.

Thanks

Thanks for the quick replies.  I found it in the help menu and am processing it right now.  I'm over an hour into the optimize function.... still 'Materializing column: Date_Time'

this may not work if it's going to take an hours to optimize.

And this was just a small part of our database... How am I going to analyze 100,000 million rows of data...

It took 84 minutes to optimize the extract and things are much much faster.  For the analysis that I'm performing today, this will work fine.

Going forward I'll need to explore options on my database end and tableau to make this faster.  Ideally we would like to create dashboards for time-of-use energy consumption patterns that will update in near real time.

I'm going to download the Tableau Performance Analyzer to help determine where the slow downs are occuring.

http://www.interworks.com/services/business-intelligence/tableau-performance-analyzer

Any other resources that I can pursue? Comments welcome...

Thanks Cristian, I'll check into the perf analyzer included in v8.  I like the suggestion of possibly going to an SSD.  Any optimization that can be done with hardware and/or file management is helpful.