SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS/Access performance-boosting methods

Reply
SAS Employee
Posts: 13

SAS/Access performance-boosting methods

We all want to boost performance of data processing, especially in light of increasing user expectations and more advanced analytics needed to take advantage of big data. There are several ways to do this through SAS/Access engines, and two SAS Global Forum 2013 papers that illustrate options:

1)     From Wells Fargo Bank: SAS-Oracle Options
and Efficiency: What You Don’t Know Can Hurt You

2)     From Knowit Decision Oslo, Norway: Need for Speed -
Boost Performance in Data Processing with SAS/Access® Interface to Oracle

  

NOTE: Most of the options reviewed in both papers are cross-database.

  

What database are you using? Please share other techniques you’ve used to improve performance.

Ask a Question
Discussion stats
  • 0 replies
  • 172 views
  • 0 likes
  • 1 in conversation