[Israel.pm] Fwd: Which DB to use with perl tie?

Kfir Lavi lavi.kfir at gmail.com
Tue Jul 10 01:07:32 PDT 2007


Problem with the links in the site:
http://www.perl.org.il/mailman/listinfo/perl/

or

 http://perl.org.il/pipermail/perl/

Gets me to the error page about "non-existing page".
Wahts the problem?

In the meantime how to subscribe to Israel.pm mailing list?
Tnx,
Kfir

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.
> http://www.perl.org.il/mailing_lists.html
> People there will most definitely will help you with this question.
> Regards,
> 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 mailing list