Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance ROracle vs. RODBC

973350Nov 8 2012 — edited Feb 8 2013

Hi,

I just set up database access for a Oracle 11g database using RODBC. However the performance is rather poor. I need to analyze several million records on a regular basis in R. However, it takes hours to get them into a data frame object (i.e. more than 15min per 1 million records).

How does the performance of ROracle look like? Do you have any benchmarks on comparing RODBC and ROracle?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2013

Added on Nov 8 2012

#r-technologies

6 comments

3,807 views