Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

Re: Disk based hash (as opposed to RAM based)

by techtruth (Novice)
on Oct 09, 2012 at 03:18 UTC ( #997913=note: print w/replies, xml ) Need Help??

in reply to Disk based hash (as opposed to RAM based)

After asking myself a series of questions about how best to do this, I believe that the best way is to load everything into a temporary database table and use the database to process all this data. I would love to use perls hashes (which is initially why I chose perl) but this approach should be the best I can come up with. I will post the code once I finish it. I am rolling my own code on this one and am not using an API or other library of code other than perl and MySQL. My thought is to load the data, and use a combination of mysqls left, substr, and other string functions to populate data in a second column with the values I would use as a key. The MySQL select...where should let me then retrieve data in a way that mirrors perls way of getting values from a hash by key. Does that make sense? I will post code later.
  • Comment on Re: Disk based hash (as opposed to RAM based)

Replies are listed 'Best First'.
Re^2: Disk based hash (as opposed to RAM based)
by Anonymous Monk on Oct 11, 2012 at 01:14 UTC
    I have ventured a little farther into mysql land than I wanted to, Still working on an issue or two that isn't relevant to the monastery, I will return.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://997913]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (6)
As of 2018-06-22 20:07 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (124 votes). Check out past polls.