in reply to Re: Selecting the right database for perl
in thread Selecting the right database for perl

Build it into hashes and arrays in perl and it will pop up to at least 100mb, get sloppy and copy instead of use refs and you can grow that amount very qucikly and cause big slowdowns. modify in memory and delay writes to disk and you can kiss it goodbye on poweroutage/system crash. Even though it may be possible (or even prudent) to do it in all memory understand the risks and problems you may be up against. If you have oracle/sybase/ms-sql licenses use what you have, else there are free databases such as mysql and postgres.

-Waswas
  • Comment on Re: Re: Selecting the right database for perl

Replies are listed 'Best First'.
Re: Selecting the right database for perl
by Abigail-II (Bishop) on Aug 19, 2003 at 21:50 UTC
    modify in memory and delay writes to disk and you can kiss it goodbye on poweroutage/system crash.

    I took an exception on transaction support. He didn't specify what kind of database he needs - if it's being modified heavily, you want to have something that makes sure no data gets lost on a crash. But if all he does is querying, having it all in memory is what you want.

    Abigail

      This is not going to be heavily modified by any means. Adding records will occur at a specific time each day. From that point on it is mostly a query and calculations of the data gathered, and then throwing results into an output file that will be read by a person.

      It is the calculations that I will do that worry me about memory.