[thelist] DB design question
matt g
mrg at members.evolt.org
Fri Dec 6 15:23:01 CST 2002
> From: Joel Canfield <joel at spinhead.com>
>
> Property table:
> address
>
> PropertyAmenities table:
> Property.address
> Amenities.amenityID
Hi,
You would want to use a regular ID in the property table, wouldn't you?
Property table:
propertyID
address
PropertyAmenities table:
Property.propertyID
Amenities.amenityID
That way, you're indexing/searching for a number rather than a string in the
PropertyAmenties table. Seems faster. Please tell me if there's a reason
that it's not.
Thanks,
matt g
More information about the thelist
mailing list