my task is to take a massive localguide database and try to normalize
the database currently consist of fields like:
company information
category main
category other
subscategory
subscategory other
list
areaoftown
an example of category main might restaurant
and category other as nightclub
subscatergory might be chinese and subscatgoryother as italian
list might be wedding
and areaoftown could be carytown
so all together it is a restaurant which is also a club that serves chinese
and italian
that caters for weddings and is located in carytown
choices seperate each category main into seperate tables so i would
restaurant, clubs, golf course, etc.
my options are seperating each table out and doing some crazy queries and
inserts.
or making a categories table and a company table and a table that houses
category id and company id.
or is there a another option that i'm overlooking
the reason for the change is that the database is being pounded around 12
and 5 each day because of queries for restaurants
please help
metzy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
