06-16-2015 05:22 PM
I have a 1T SSD drive on my PC to reduce the running time. What I did is that I created a library, named TEMP, in the ssd drive (G, and when I write the code, I determined the output to be saved in that library. However, I do not see any significant difference in the speed. Is that the right way of using ssd to speed up or I need to change the directory of my library to the ssd drive and then using work library?
I appreciate any suggestion.
06-16-2015 07:48 PM
You should make the SAS Drive your work drive as already stated, but also when you write a query that requires data from other locations, you should bring that data down to your SSD first. So preselects into tables into your work folder which you have defined on your SSD will help a lot too. I started looking at the locations of the data throughout my processes and to get the most out of my processing, I find brining that data down to the local drive works the best. We are working with moderate sized data sets of a few 100 million rows each and I see a huge difference in processing time.
Need further help from the community? Please ask a new question.