From: Michael Davis <mdavis@...>
Date: 2002-01-16T03:53:14+09:00
Subject: Re: memory usage question

Mark Hahn wrote:

>>you should consider using a database
>>
> 
> Doing 200 million lookups in a db would take way too long for my script.  If
> there is no other work-around than using a DB, then I'll have to go back to
> Java, which can handle this kind of memory usage.  I'm dissapointed that in
> one of the first quick scripts I went to Ruby for, Ruby couldn't do the job.
> 
> 

Have you considered using a btree?  There is a btree class in Aruna (at 
www.arunadb.org) that will allow you to set the page size such that only 
  one I/O is needed to find the value you are looking for.

-- 
Michael Davis
Database Architect and Senior Software Engineer, Seva Inc.
Email: mdavis@sevainc.com