Rita 2012-09-15, 15:09
Stack 2012-09-16, 22:16
Yes, I am trying to save on disk space because of limited resouces and the
table will be around 30 billion rows.
The lookup table itself will be around 9k rows so its not too bad. A
character's range will be from 1 to 4.
I suppose I really should worry about it too much.
On Sun, Sep 16, 2012 at 6:16 PM, Stack <[EMAIL PROTECTED]> wrote:
> On Sat, Sep 15, 2012 at 8:09 AM, Rita <[EMAIL PROTECTED]> wrote:
> > I am debating if a lookup table would help my situation.
> > I have a bunch of codes which map with timestamp (unsigned int). The
> > look like this
> > AA4
> > AAA5
> > A21
> > A4
> > ...
> > Z435
> > The size range from 1 character to 4 characters (1 to 4 bytes,
> > respectively).
> > Would adding a lookup table for all my codes help in reducing space? If
> > what would be the best way to hash something like this?
> You are trying to save on disk space? You could make your keys binary
> four bytes max null prefixed if < 4 characters? Why are you trying to
> save disk space? You want a lookup table so you can have a code that
> is smaller than that of the 1-4 character codes?
--- Get your facts first, then you can distort them as you please.--
Tom Brown 2012-09-17, 01:57
Stack 2012-09-17, 16:23