03-28-2018 09:14 AM
I am trying to load 30gb of data from Denedo to SAS and this is running very slow. As 10gb of data loading from denedo took 12.5hrs
and 5gb data loading took 6hrs.
Are there any factors that can be changed in any of the config files to have a better performance in loading data. Please suggest. Thanks!!
03-28-2018 10:08 AM
Performance depends on so many factors that suggesting something is difficult without full-knowledge about the environment involved. I would start by checking network connections and their utilisation. Working with tech-support is recommended.
03-28-2018 10:15 AM
The network is a huge factor. Those options might help you get a better understanding what is going on when you loading the data in SAS.
options fullstimer source source2 msglevel=i mprint notes; options sastrace=",,,dsa" sastraceloc=saslog nostsuffix;