« A first look at Oracle on Amazon RDS | Main | RORACLE vs RJDBC »
Friday
May202011

RJDBC 2.0 performance improvements

But hopefully this will be the last RJDDC posting the I make for a while :-).

Simon Urbanek has made some fixes to RJDBC which resolve the performance issues five referred to in my last post.  As you can see below, these fixes have led to a pretty dramatic performance improvements:

17-05-2011 10-29-16 AM RJDBC 2.0

Furthermore, RJDBC is substantially easier to install than Roracle, and is of course portable across different databases.

If you’re really concerned with RJDBC performance and have memory to burn you can improve performance someone by selecting all rows in a single internal fetch, like this:

jdata2<-fetch(dbSendQuery(jcon,sqltext),n=rowsToFetch);

This improves performance, though Roracle still has the advantage:

18-05-2011 10-56-47 AM RJDBC2

You can get the new RJDBC here.

Reader Comments (3)

Thank you for the post.. I have a problem to resolve: is there the possibility to call Oracle stored procedure inside R?

example call my_package.my_proc(ID1, ID2); ??

Thank you in advance

JC.

November 3, 2012 | Unregistered CommenterJC

How about the performance of RODBC against RJDBC and ROracle?

November 9, 2012 | Unregistered CommenterMM

I am also interested inthe performance of Roracle vs rodbc. Same initials, but different person from above comment. :)

November 16, 2012 | Unregistered CommenterMike

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>