A
Andreas Sonnenbichler
Hello,
maybe, its a too simple question, but I don't know where to start:
I have a extremely big hash (almost 1GB mem), looking like this:
$hash->{$id}->{$row}.
I want to store this hash in ONE MySQL database table, so that $id marks one
db entity, and all keys (in row) are stored together in one other db field.
Like this:
+++++++++++++++++++++++++++++++++++++++++
+ ID + Value +++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++++++++++++
+ id1 + id1-row1, id1-row2, id1-row3, ...
+ id2 + id2-row1, id1-row3, id1-row7, ...
Is there any FAST possibility. I mean, of course I can concatenate all
row-values and write the resulting hash manually by any loop writeing all
id's. But is there something thats makes it faster? Like tieing or so?
Andreas
maybe, its a too simple question, but I don't know where to start:
I have a extremely big hash (almost 1GB mem), looking like this:
$hash->{$id}->{$row}.
I want to store this hash in ONE MySQL database table, so that $id marks one
db entity, and all keys (in row) are stored together in one other db field.
Like this:
+++++++++++++++++++++++++++++++++++++++++
+ ID + Value +++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++++++++++++
+ id1 + id1-row1, id1-row2, id1-row3, ...
+ id2 + id2-row1, id1-row3, id1-row7, ...
Is there any FAST possibility. I mean, of course I can concatenate all
row-values and write the resulting hash manually by any loop writeing all
id's. But is there something thats makes it faster? Like tieing or so?
Andreas