Joel, if you want to have your database relational to 3rd normal form then yes you should have separate tables for all of your lookups. Databases are designed to work well with joins of that nature and if you build your indexes correctly you should be ok. A lot of people forget to add indexes on foreign key columns which will obviously hurt performance.
For improved performance you could build views that join the tables together. Views are faster than running plain old select queries and doing all the joins. -- Gary Gilbert http://www.garyrgilbert.com/blog ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
