From: Paul Lutus <nospam@...>
Date: 2006-11-16T04:15:04+09:00
Subject: Re: Assoc method on large array

gregarican wrote:

> I didn't let the DB do the selection because I was querying different
> databases residing on different servers and combining the results in a
> way that I didn't feel like jumping through SQL hoops for. Since I like
> coding in Ruby better than coding in SQL I figured I'd let Ruby do the
> heavy lifting. Looking at it, a Hash object would be better suited for
> some of this work. Next time I will utilize this type of object.

In the case of records from different databases on different servers, I
strongly suggest that you test each field of each record for agreement with
what the field should contain. This may solve the original problem of
mysterious behavior on large data sets -- it may have been an unexpected
field content, one that wasn't what it should have been.

Simply go through each field and test that it is what you expect, and
convert it if it isn't. This will take some time, but the entire procedure
is failing right now, and that is worse IMHO.

-- 
Paul Lutus
http://www.arachnoid.com