From: pat eyler <pat.eyler@...>
Date: 2006-03-22T23:06:23+09:00
Subject: Re: Ruby performance

On 3/22/06, Keith Sader <ksader@gmail.com> wrote:
> I'm considering using Ruby to re-write and extract, transform, and
> load process for an online database.  This will replace an existing VB
> system that does most of the T of the ETL in T-SQL(don't ask).
>
> My replacement choices come down to .Net(C# or VB), Perl, and Ruby.
> Since we can have up to 3 million updates to the database during the
> day, performance is an issue.  Does Ruby perform as well at large text
> file transformations as Perl?  Does C# for that matter?
>
> At this point my gut feeling is to write the ETL in Ruby and transform
> it to Perl if performance becomes an issue.

Write it in Ruby, then if you have performance issues -- profile,
benchmark, and optimize.   If you really get stuck RubyInline will
be your friend *far* more than Perl ever would.


>
> Any thoughts?
>
> thanks,
> --
> Keith Sader
> ksader@gmail.com
> http://www.saderfamily.org/roller/page/ksader
>
>


--
thanks,
-pate
-------------------------