Architecting, installing and maintaining your SAS environment

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

Reply
Frequent Contributor
Posts: 96

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

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

Valued Guide
Posts: 516

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

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.

SAS Employee
Posts: 512

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

@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;
Ask a Question
Discussion stats
  • 2 replies
  • 119 views
  • 2 likes
  • 3 in conversation