From: Kyle Schmitt <kyleaschmitt@...>
Date: 2010-04-24T05:55:17+09:00
Subject: Re: When to use a db?

On Thu, Apr 22, 2010 at 1:43 PM, Brian Candler <b.candler@pobox.com> wrote:
> Moya Pilot wrote:
>> Will using a SQLite DB be faster or easier or more efficient for me than
>> just doing all my iterations thru an array?
>
> Unless your data structure won't fit in RAM, then you'll be better off
> using a Hash (so you can locate the object you're interested straight
> away, rather than iterating through an Array)

Actually, if your data won't fit in RAM, you still probably want to do
it in a hash.  Just use BDB or GBDM.  Those are more or less just fast
on-disc hashes.  Before everything was SQL (back when dinosaurs roamed
the earth), that's what folks called a database.

--Kyle