[Israel.pm] Fwd: Which DB to use with perl tie?
lavi.kfir at gmail.com
Tue Jul 10 01:07:32 PDT 2007
Problem with the links in the site:
Gets me to the error page about "non-existing page".
Wahts the problem?
In the meantime how to subscribe to Israel.pm mailing list?
On 10/07/07, Kfir Lavi <lavi.kfir at gmail.com> wrote:
> Hi Amos,
> there is a mailing list and active group of perl users in Israel. It
> called israel.pm.
> Here is a link to our site and mailing list.
> People there will most definitely will help you with this question.
> Kfir Lavi
> On 7/10/07, Amos Shapira <amos.shapira at gmail.com > wrote:
> > Hi All,
> > Which DBM file is recommended to be used with Perl5 "tie"?
> > Context: I intend to write a database statistics script which will go
> > through a largish database and count instances per-day or per-hour. For
> > instance one count will be "number of people who sent a message in each day
> > of the year".
> > In order to keep track of each submitter (e.g. if Joe Shmoe sent two
> > messages on July 4th I want to count him once) I plan to use a simple hash
> > array of "data,username".
> > Since it could become a very large hash (total of 140k individuals, times
> > number of days in the last couple of years makes it over 100 million
> > potential records), I think that tie'ing it to a DBM file will help
> > alleviate the memory requirements.
> > Question is - which DBM file would be recommended? I suppose I should look
> > for speed. Berkeley DB is almost the default but my experience with it (not
> > through perl tie, but direct programming in C++) was that it's not 100%
> > reliable (it's very fragile), and there is GDBM, and GNU are known to do
> > some cool stuff.
> > The file might be transient (once the count is over I'll keep it in a
> > PostgresQL 8.1 database), but maybe I'll keep it around for the updates.
> > Any thoughts? Personal war stories?
> > Thanks,
> > --Amos
More information about the Perl