JDBC Activerecord Gem

Ruby JRuby
1

What are the advantages of using the JDBC AR gem? Does it just
translate
all AR calls to JDBC for faster perf than the pure ruby solution? Are
there
any disadvantages?

thanks for any thoughts…
phil

2

On Sun, Jun 22, 2008 at 11:41 PM, phil swenson [email protected]
wrote:

What are the advantages of using the JDBC AR gem? Does it just translate
all AR calls to JDBC for faster perf than the pure ruby solution? Are there
any disadvantages?

Basically, yes.

The disadvantages are that we have a separate codebase from Rails
proper, do not pass all the ActiveRecord unit tests, and thus may have
some corner cases that don’t work. We appreciate bug reports and
patches for those. Hopefully this will get better over time as well.

Another small disadvantage is the versioning hell we’ve had to deal
with trying to stay compatible with multiple versions of Rails and
JRuby (especially JRuby API changes). When in doubt, try the latest
versions of JRuby and Rails with the latest AR-JDBC gem to ensure you
don’t run into problems. Also report to the list if you see any and
I’ll try to help clarify.

The upside is that with JDBC the list of target databases is pretty
big. We’ve even heard reports of a JRuby on Rails application run on
an IBM z/OS mainframe talking to a DB2 database.

HTH,
/Nick

To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email
3

Any idea how much perf increase you get for AR-JDBC vs plain old AR?
I’m
just going against mysql, so trying to decide which way to go.

thanks

4

We’ve done some benchmarks in the past but I don’t have any numbers
available right now. The best thing would be for you to craft a simple
benchmark yourself, like performing 100 queries in a loop or
something, and do the same script with adapter: mysql (pure ruby) vs.
adapter: jdbcmysql. I think you’ll find a speedup in the range of
25-100% depending on the operation. Not orders of magnitude faster but
definitely measurable.

/Nick

On Mon, Jun 23, 2008 at 11:19 AM, phil swenson [email protected]
wrote:

translate

To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email