How to improve the performance of loading data into cas from db: Viya 3.3

[AmitSri]

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!!

[andreas_lds]

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.

[alexal]

@AmitSri,

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;