https://communities.sas.com/t5/Administration-and-Deployment/How-to-improve-the-performance-of-loading-data-into-cas-from-db/m-p/449309#M12725 <P>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</P><P>and 5gb data loading took 6hrs.<BR /><BR />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!!</P> Wed, 28 Mar 2018 13:14:36 GMT AmitSri 2018-03-28T13:14:36Z https://communities.sas.com/t5/Administration-and-Deployment/How-to-improve-the-performance-of-loading-data-into-cas-from-db/m-p/449309#M12725 <P>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</P><P>and 5gb data loading took 6hrs.<BR /><BR />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!!</P> Wed, 28 Mar 2018 13:14:36 GMT https://communities.sas.com/t5/Administration-and-Deployment/How-to-improve-the-performance-of-loading-data-into-cas-from-db/m-p/449309#M12725 AmitSri 2018-03-28T13:14:36Z https://communities.sas.com/t5/Administration-and-Deployment/How-to-improve-the-performance-of-loading-data-into-cas-from-db/m-p/449328#M12726 <P>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.</P> Wed, 28 Mar 2018 14:08:01 GMT https://communities.sas.com/t5/Administration-and-Deployment/How-to-improve-the-performance-of-loading-data-into-cas-from-db/m-p/449328#M12726 andreas_lds 2018-03-28T14:08:01Z https://communities.sas.com/t5/Administration-and-Deployment/How-to-improve-the-performance-of-loading-data-into-cas-from-db/m-p/449330#M12728 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/166025">@AmitSri</a>,</P> <P>&nbsp;</P> <P>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.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">options fullstimer source source2 msglevel=i mprint notes; options sastrace=",,,dsa" sastraceloc=saslog nostsuffix;</CODE></PRE> Wed, 28 Mar 2018 14:15:32 GMT https://communities.sas.com/t5/Administration-and-Deployment/How-to-improve-the-performance-of-loading-data-into-cas-from-db/m-p/449330#M12728 alexal 2018-03-28T14:15:32Z