From: Jeremy Hinegardner <jeremy@...>
Date: 2006-11-11T02:34:47+09:00
Subject: Re: Flat CSV to Relational DB

On Fri, Nov 10, 2006 at 03:08:11AM +0900, Michael Guterl wrote:
> On 11/8/06, Jeremy Hinegardner <jeremy@hinegardner.org> wrote:

[...] 

> >Sometimes I've had to have ruby reprocess the csv file to get into the
> >quoted format that the db import command format, but in the overall
> >time, it was actually faster to process the CSV file and have the db
> >load it natively than to have ruby process the CSV file and do the
> >inserts via ActiveRecord or the DBI interface.
> >
> I do like this suggestion, do all the CSV manipulations, then pass off
> to the appropriate DB command.  I will have to investigate these
> options further.

Glad to help.  Let us know how it turns out.

enjo,

-jeremy

-- 
========================================================================
 Jeremy Hinegardner                              jeremy@hinegardner.org