Dear Team,
I have created a batch data job which is taking 10 hours to read having 3 crores of Rows. Please suggest how to improve the performance in SAS Data Management Server ?
I have attached one screenshot for your references. it may be taking long time to read the data from ORACLE db.
Let me know if required any further details
Thank You
Shakti
Have you tried running just reading of Oracle part? I suggest you make a copy of your job and delete all except the first four tasks - up to Data Union 1. Then test how long that takes. Your job will not be any faster than how long it takes to read your data.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.