By default, accessing third party relational databases can be very slow if not configured properly. I recently started using PostgreSQL 9.1, an open source database, to store high volumes of data for my SAS Global Forum 2013 paper. At first it was taking forever to load up data because SAS was inserting 1 row at a time into the database table. After adding a simple option my data processing was off to the races!
AnalyticBridge
Data Intelligence, Business Analytics
Working with Big Data in SAS BI
Steve Overton is working on his SAS Global Forum 2013 paper idea! I don't want to give away his secret - but he wants to show some ways to work with Big Data. First he has to load the big data into his demo system - here's some tricks he has learned.
Do you know some others? Share them!
SAS Administration: Process Data Faster in RDBMS by Buffering the Data in Memory
Comments are closed for this blog post
Top Content
Follow us
Big Data Jobs
© 2013 AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC
