Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: Improving Memory Efficiency with Storable and Hashes of Scalars (code) no help at all here

by baku (Scribe)
on Jun 01, 2001 at 09:28 UTC ( #84857=note: print w/replies, xml ) Need Help??


in reply to Improving Memory Efficiency with Storable and Hashes of Scalars (code)

It sounds like a "sequential write" is exactly what you need here...

Why not loop over each source file and append them to your output?

If that's not plausible for some reason, something like Berkeley DB could very well be a solution, but given the sizes you're talking about (600M of plain text, plus presumably some amount of metadata, eg. filenames, plus the overhead and index of the DB file itself), you might be running into the maximum filesize of the DB format (IIRC, DB_File's can only be 2G) in the very near future.

I assume there's a driving reason this isn't being dumped into binary records in Oracle?

Um, good luck regardless!

  • Comment on Re: Improving Memory Efficiency with Storable and Hashes of Scalars (code) no help at all here

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://84857]
help
Chatterbox?
[atcroft]: abner: So you are wanting to do something like my $sth = $dbh->prepare(' SELECT * FROM charge WHERE col1 = ? and col2 = ?;'); $sth->execute(' asdf', 'asdw');?
[atcroft]: (Full disclosure: I may have the idea right but small typographical errors, so please test any code I suggest. :) )
[atcroft]: abner: Or are you wanting to do something where you need to bind an array to a placeholder (in which case the bind_param_array method may be of use.

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (6)
As of 2017-01-24 03:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you watch meteor showers?




    Results (202 votes). Check out past polls.