1 of 1 people found this helpful
Create a large ram disk and copy your tableau files there. Don't forget to reconfigure Tableau's TEMP and TMP environment variables.
Read this thread, could give you some hints Hardware for the best Tableau performance
Thanks Cristian. I went through the thread. It totally make sense. Which software you recommend for RamDisk?
Thanks Christian! I will give it a try.
The only thing a RAM disk will give you is the ability to load columns in the TDE file into RAM a bit faster vs. grabbing them off a mechanical disk. This will help some, but it sounds like your goal is to actually "pin" the whole extract in memory from the beginning.
We don't do this (on purpose). We only load columns from the extract into RAM when they are actually required to answer a question.
You can force the columns to load with this hack:
- On an otherwise empty sheet, add a filter that allows 1 row to be returned from your data.
- Add each and every dimension in the extract to Level of Details or (if a measure) to Rows/ Columns
- You are not interested in creating a usable viz, by the way.
Using the steps above will force Tableau to load each column on L.O.D. or Rows/Columns into memory...even though only 1 row is returned to the throw-away report.
Now, run other reports.
By the way, if you have "slow" reports, simply pre-loading data into RAM may not make that much of a difference anyway - for example, if you're doing "expensive" things like DISTINCT COUNTs, they're still going to be expensive and take a while...
Russel, thanks for explaining how to do that forced load