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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200310101243
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

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