>But what percent of the addresses have an extension. Seems to me right now you're using 8 bytes (4 for the integer and 4 for the extension) when you could probably do the whole thing with 6 bytes for the character combination.
>
>Aside from which, hard drives are cheap. Space is irrelevant unless your table is so big that you're facing the 2gig limit.
>
>Tamar
Hi Tamar,
Actually, quite a big number of addresses have extension. At least 20% of records, I would say. And the structure of our tables have been created before I came there.
If it's not broken, fix it until it is.
My Blog