Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

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]
Corion had a meeting with some startup today. They have a very interesting DB proxy product, but their tech stack is really, really weird. They use the Pg wire protocol but not the Pg libraries to handle it. They support Pg SQL syntax, but don't use ...
[Corion]: ... the Pg parser (or so they claim).

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2018-04-19 12:13 GMT
Find Nodes?
    Voting Booth?