Hi, Monks.

For reasons probably best described as DBI, I have data like this:

%dat_by_id = (
    1=>{
     id=>1, sn=>'a', more=>'foo'
    }, 
    2=>{
     id=>2, sn=>'b', more=>'bar'
    }
);
[download]

You get the idea.

Now, for reasons best described as argh! I also do:

Sadly I do need to reference entries be either field throughout the rest of the code.

Is there a better way? (My dataset runs to a few million records. Big but not too big.)

I don't (currently) need a 3rd,4th,...nth field, but it's only a matter of tiem untill someone adds a UID field, or something else to compicate my life