Re: Compare rows

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> The most efficient way for you to store data would be like this:
> main table
> id  address
> 3   67.92
> 7   69.5
>
> child table
> id  value_type  value
> 3   uptime      0.3
> 3   memory      37
> 7   uptime      1.1
> 7   memory      15

Actually, a more efficient* way is this:

value table
vid value_name
1  uptime
2  memory

child table
id   vid   value
3     1     0.3
3     2     37
7     1     1.1
7     2     15


* Still not necessarily the *most* efficient, depending on how the
values are distributed, but it sure beats storing "uptime" over
and over again. :)


- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200310101243
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE/huHxvJuQZxSWSsgRAiMNAKD4kQCwdv3fXyEFUu64mymtf567dwCcCKd5
ZzJaV7wjfs00DBT62bVpHhs=
=32b8
-----END PGP SIGNATURE-----