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:

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:

You can get the new RJDBC here.

Comments

[JC]

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.

[MM]

How about the performance of RODBC against RJDBC and ROracle?

[Mike]

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