08-21-2013 03:02 PM
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.